BIP query for Public Holiday assigned based on asg work location and showing in Calendar event

Summary:

BIP query for Public Holiday assigned based on assignment work location and showing in View Calendar event in work Schedual.

Content (required):

-- AND PCEC.TREE_NODE_ID = POTNV.TREE_NODE_ID -- This Join is not available in PER_ORG_TREE_NODE_V 

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT distinct 

  papf.person_number person_number,

  pcet.name Holiday_NAME,

  ZSD.start_date_time,

 TO_CHAR(ZSD.start_date_time,'DD-Mon-YYYY','NLS_DATE_LANGUAGE=ENGLISH') Holiday_Start_Date,

 TO_CHAR(ZSD.end_date_time, 'YYYY/MM/DD') Holiday_End_Date,