per_availability_details.get_availability_details

Team,

We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_START_DATE) and time period end date (:TC_END_DATE).

We are trying to use the function per_availability_details.get_availability_details. But is there any way to pass the assignment id dynamically and fetch all the assignment timecard records for the period passed in parameters :TC_START_DATE and :TC_END_DATE?

We are able to use this function as column and get hours for one day.

But we want for more assignments for the whole week. (need to use as it as table). Please share if you have an idea. Thanks in Advance.