DBA Data[Home] [Help]

APPS.PAY_PYAUPYT_XMLP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 15: PAY_ASSIGNMENT_ACTIONS PAA

11: AND ACTION_CONTEXT_ID in (
12: SELECT
13: PAA.ASSIGNMENT_ACTION_ID
14: FROM
15: PAY_ASSIGNMENT_ACTIONS PAA
16: WHERE PAA.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID_LP );
17: DELETE FROM PAY_ACTION_INFORMATION
18: WHERE ACTION_INFORMATION_CATEGORY = 'AU_ARCHIVE_ASG_DETAILS'
19: AND ACTION_INFORMATION2 = P_PAYROLL_ACTION_ID_LP;

Line 20: DELETE FROM PAY_ASSIGNMENT_ACTIONS PAA

16: WHERE PAA.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID_LP );
17: DELETE FROM PAY_ACTION_INFORMATION
18: WHERE ACTION_INFORMATION_CATEGORY = 'AU_ARCHIVE_ASG_DETAILS'
19: AND ACTION_INFORMATION2 = P_PAYROLL_ACTION_ID_LP;
20: DELETE FROM PAY_ASSIGNMENT_ACTIONS PAA
21: WHERE PAA.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID_LP;
22: DELETE FROM PAY_PAYROLL_ACTIONS PPA
23: WHERE PPA.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID_LP;
24: EXCEPTION