DBA Data[Home] [Help]

APPS.PAY_PYAUPYT_XMLP_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 22: DELETE FROM PAY_PAYROLL_ACTIONS PPA

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
25: WHEN OTHERS THEN
26: ROLLBACK;