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

How to pass parameters to the post SQL bind query in the custom payroll flow?

Summary:

How to pass parameters to the post SQL bind query in the custom payroll flow?

Content (required):

Hi experts,

Is it possible to pass flow parameter value to the subsequent parameter based on the post SQL bind query in the custom payroll flow?

Here is a code snippet:

Select   distinct min(to_Char( PTP.END_DATE , 'YYYY.MM' )) from PAY_TIME_PERIODS PTP JOIN PAY_ALL_PAYROLLS_F P   on P.PAYROLL_ID = PTP.PAYROLL_ID   AND trunc(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE and P.EFFECTIVE_END_DATE JOIN PER_LEGISLATIVE_DATA_GROUPS LEG   ON P.LEGISLATIVE_DATA_GROUP_ID = LEG.LEGISLATIVE_DATA_GROUP_ID JOIN FND_TERRITORIES_TL TER   ON LEG.LEGISLATION_CODE = TER.TERRITORY_CODE   AND TER.LANGUAGE = 'US' JOIN HRY_PI_INBD_RECORDS IR   ON IR.FUNCTIONAL_CATEGORY = 'AA'   AND IR.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID   AND IR.PAYROLL_ID = PTP.PAYROLL_ID WHERE (   NOT Exists(     Select 1     FROM HRY_PI_INBD_RECORDS PR     WHERE PR.FUNCTIONAL_CATEGORY = 'AA_RPT'     AND PR.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID     AND PR.PAYROLL_ID = PTP.PAYROLL_ID     GROUP BY PR.TIME_PERIOD_ID   )   AND (     TER.TERRITORY_CODE IN ( :LEGISLATIVE_COUNTRY )   ) )

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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