Calendar events and Work Schedule Tables and joins

Summary

Calendar events and Work Schedule Tables and joins

Content

Hi all,
 

I have a requirement to get Holiday Calendar.I got the the Holiday Name and Holiday Type from  
    per_cal_event_coverage ,
   per_calendar_events_tl ,
   per_calendar_events  

 

tables.
But, I need to link with employee work schedule  by using followings,

PER_SCHEDULE_ASSIGNMENTS
PER_SCHEDULE_EXCEPTIONS
 

 

help me

Thanks in advance!!

 

 

Thanks & Regards,