I have requirement to get Holiday Calendar for particular regions (location). I got the the Holiday Name and Holiday Type from PER_CALENDAR_EVENTS_VL View but I cannot find a link to join this to Location.
Please provide a SQL Query join and table name to connect PER_CALENDAR_EVENTS_VL. FYI, I just want to get Holiday Days. I am currently working on Oracle Fusion Cloud 19C Version.
Thanks in advance!!
Thanks & Regards,