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 ) ) )