DBA Data[Home] [Help]

APPS.PAY_REVERSE_PAYROLL_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 20: PAY_ASSIGNMENT_ACTIONS PAA,

16: SELECT PAY_PAYROLL_ACTIONS_S.NEXTVAL,
17: PTP.TIME_PERIOD_ID,
18: PAC.DATE_EARNED
19: FROM PER_TIME_PERIODS PTP,
20: PAY_ASSIGNMENT_ACTIONS PAA,
21: PAY_PAYROLL_ACTIONS PAC
22: WHERE PTP.PAYROLL_ID = P_PAYROLL_ID
23: AND P_EFFECTIVE_DATE BETWEEN
24: PTP.START_DATE AND PTP.END_DATE