DBA Data[Home] [Help]

APPS.PA_PAY_INTERFACE dependencies on PA_PAY_EXTERNAL_PAYROLL

Line 233: PA_PAY_EXTERNAL_PAYROLL PPEP

229: PPEI.RETRO_PERIOD_END_DATE,
230: PPEP.PRIORITY
231: FROM
232: PA_PAY_EXT_INTERAFACE_V PPEI,
233: PA_PAY_EXTERNAL_PAYROLL PPEP
234: WHERE PPEP.PAYROLL_ID = PPEI.PAYROLL_ID AND
235: Trunc(PPEI.TIME_PERIOD_END_DATE) BETWEEN P_DATE_START AND P_DATE_END
236: AND PPEI.PAYROLL_ID = Nvl(P_PAYROLL_ID,PPEI.PAYROLL_ID)
237: AND PPEI.PERSON_ID = Nvl(P_PERSON_ID,PPEI.PERSON_ID)