APPS.PAY_REVERSE_PAYROLL_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 16: SELECT PAY_PAYROLL_ACTIONS_S.NEXTVAL,

12: P_ACTION_STATUS VARCHAR2,
13: P_EFFECTIVE_DATE DATE,
14: P_ASSIGNMENT_ACTION_ID NUMBER) IS
15: CURSOR C1 IS
16: SELECT PAY_PAYROLL_ACTIONS_S.NEXTVAL,
17: -- PTP.TIME_PERIOD_ID,
18: PAC.TIME_PERIOD_ID,
19: PAC.DATE_EARNED
20: FROM -- PER_TIME_PERIODS PTP,

Line 22: PAY_PAYROLL_ACTIONS PAC

18: PAC.TIME_PERIOD_ID,
19: PAC.DATE_EARNED
20: FROM -- PER_TIME_PERIODS PTP,
21: PAY_ASSIGNMENT_ACTIONS PAA,
22: PAY_PAYROLL_ACTIONS PAC
23: WHERE -- PTP.PAYROLL_ID = P_PAYROLL_ID
24: -- AND P_EFFECTIVE_DATE BETWEEN
25: -- PTP.START_DATE AND PTP.END_DATE
26: -- AND

Line 36: INSERT INTO PAY_PAYROLL_ACTIONS(PAYROLL_ACTION_ID, ACTION_TYPE,

32: OPEN C1;
33: FETCH C1 INTO P_PAYROLL_ACTION_ID, L_TIME_PERIOD_ID, L_DATE_EARNED;
34: CLOSE C1;
35:
36: INSERT INTO PAY_PAYROLL_ACTIONS(PAYROLL_ACTION_ID, ACTION_TYPE,
37: BUSINESS_GROUP_ID, CONSOLIDATION_SET_ID,
38: PAYROLL_ID, ACTION_POPULATION_STATUS,
39: ACTION_STATUS,EFFECTIVE_DATE, DATE_EARNED,
40: TIME_PERIOD_ID,