Calendar events and Work Schedule Tables and joins
Summary
Calendar events and Work Schedule Tables and joinsContent
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,
0