APPS.PAY_PYAUPYT_XMLP_PKG dependencies on PAY_ACTION_INFORMATION

Line 6: DELETE FROM PAY_ACTION_INFORMATION

2: /* $Header: PYAUPYLB.pls 120.0 2007/12/13 12:14:38 amakrish noship $ */
3: FUNCTION AFTERREPORT RETURN BOOLEAN IS
4: BEGIN
5: BEGIN
6: DELETE FROM PAY_ACTION_INFORMATION
7: WHERE ACTION_INFORMATION_CATEGORY = 'AU_PAYROLL_TAX_EMPLOYEE_DETAILS'
8: AND ACTION_CONTEXT_ID = P_PAYROLL_ACTION_ID_LP;
9: DELETE FROM PAY_ACTION_INFORMATION
10: WHERE ACTION_INFORMATION_CATEGORY in ( 'AU_PAYROLL_TAX_DGE_DETAILS' , 'AU_PAYROLL_TAX_BALANCE_DETAILS_YTD' )

Line 9: DELETE FROM PAY_ACTION_INFORMATION

5: BEGIN
6: DELETE FROM PAY_ACTION_INFORMATION
7: WHERE ACTION_INFORMATION_CATEGORY = 'AU_PAYROLL_TAX_EMPLOYEE_DETAILS'
8: AND ACTION_CONTEXT_ID = P_PAYROLL_ACTION_ID_LP;
9: DELETE FROM PAY_ACTION_INFORMATION
10: WHERE ACTION_INFORMATION_CATEGORY in ( 'AU_PAYROLL_TAX_DGE_DETAILS' , 'AU_PAYROLL_TAX_BALANCE_DETAILS_YTD' )
11: AND ACTION_CONTEXT_ID in (
12: SELECT
13: PAA.ASSIGNMENT_ACTION_ID

Line 17: DELETE FROM PAY_ACTION_INFORMATION

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;
20: DELETE FROM PAY_ASSIGNMENT_ACTIONS PAA
21: WHERE PAA.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID_LP;