For more information, please refer to this announcement explaining best practices for getting answers to questions.
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 ) ) )