What's new in Customer Journeys?

Connect and learn more! ×
BIP query for Public Holiday assigned based on asg work location and showing in Calendar event — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Accepted answer
175
Views
2
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!