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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Alert composer With SQL query

Summary:

we have sql query the rerurn some employees person_id we need to use that query in alert composer

to send them a reminder

Content :

SELECT t1.Person_IDFROM PER_ALL_ASSIGNMENTS_M T1, PAY_ELEMENT_ENTRIES_F EE,PAY_ELEMENT_ENTRY_VALUES_F EEV

WHERE EE.ELEMENT_ENTRY_ID = EEV.ELEMENT_ENTRY_ID

AND EE.ELEMENT_TYPE_ID = 300000603183844AND EEV.INPUT_VALUE_ID = 300000604012993and T1. person_id =EE.PERSON_ID

AND EEV.SCREEN_ENTRY_VALUE NOT IN(

SELECT EEV.SCREEN_ENTRY_VALUEFROM PAY_ELEMENT_ENTRY_VALUES_F EEV,PAY_ELEMENT_ENTRIES_F EEWHERE EE.ELEMENT_ENTRY_ID = EEV.ELEMENT_ENTRY_IDAND EE.ELEMENT_TYPE_ID = 300000603187127AND EEV.INPUT_VALUE_ID = 300000603188789

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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