SQL query to fetch public holiday according to the work schedule of an employee.

Summary:

need a SQL query that fetches public holiday according to the work schedule of an employee.

Content (please ensure you mask any confidential information):

I need to create a value set to be used in fast formula that fetches the PH according to the work schedule.
this query fetches all the PH according to geographic node

SELECT
D.pk1_start_value as country_code,
B.name,
to_char(C.start_date_time,'DD-MM-YYYY') as start_date, to_char(C.end_date_time,'DD-MM-YYYY') as end_date
FROM
per_cal_event_coverage A,
per_calendar_events_tl B,
per_calendar_events C,