SQL function to get the employee schedule details

                               SQL function to get the employee schedule details

To get the employees availability as per their schedule using the below function:

TABLE(per_availability_details.get_schedule_details(p_resource_type => 'ASSIGN', p_resource_id => <assignment_id> ,p_period_start => <Start_date> ,p_period_end =>  <End_date> ))  

Example:

SELECT  

*

 FROM

TABLE(per_availability_details.get_schedule_details(p_resource_type => 'ASSIGN', p_resource_id => 300000008682319 ,p_period_start => to_date('17-10-2021','DD-MM-YYYY') ,p_period_end => to_date('23-10-2021','DD-MM-YYYY') ))  

WHERE 

availability_code = 'AVL'

It may helpful for you. please visit the blog for more information and share your ideas.

Thanks

Sainath