Reports (BIP) – Function to get weekly schedule details

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'