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.DATE_EARNED
19: FROM PER_TIME_PERIODS PTP,
20: PAY_ASSIGNMENT_ACTIONS PAA,

Line 21: PAY_PAYROLL_ACTIONS PAC

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
25: AND PAA.ASSIGNMENT_ACTION_ID = P_ASSIGNMENT_ACTION_ID

Line 34: INSERT INTO PAY_PAYROLL_ACTIONS(PAYROLL_ACTION_ID, ACTION_TYPE,

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