Get Scheduled Hours From Assignment Work Schedules
We have a requirement to get the scheduled hours from Assignment Work Schedules.
We are trying with the below code but its not giving hours.
SELECT *
FROM
(
TABLE(PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS
(P_RESOURCE_TYPE => 'ASSIGN'
,P_RESOURCE_ID => '300000173930572'
,P_PERIOD_START => TO_DATE('2023-07-16','YYYY-MM-DD')
,P_PERIOD_END => TO_DATE('2023-07-22','YYYY-MM-DD')
)))
It would be helpful if you can provide any inputs on this.