Inspire growth, embrace learning
Use below query to get weekly schedule details of a worker:
select PER_AVAILABILITY_DETAILS.GET_WEEKLY_SCH_DETAILS (ASSIGNMENT_ID, TRUNC(SYSDATE,'D') + 1) Weekly_Schedule from per_All_assignments_m where assignment_type = 'E'