APPS.PAY_PYAURECD_XMLP_PKG dependencies on PAY_ACTION_INFORMATION

Line 201: DELETE FROM PAY_ACTION_INFORMATION

197: FUNCTION AFTERREPORT RETURN BOOLEAN IS
198: BEGIN
199: IF LP_DELETE_ACTIONS = 'Y' THEN
200: BEGIN
201: DELETE FROM PAY_ACTION_INFORMATION
202: WHERE ACTION_INFORMATION_CATEGORY = 'AU_EMPLOYEE_RECON_DETAILS'
203: AND ACTION_CONTEXT_ID = LP_PAYROLL_ACTION_ID;
204: IF P_PAYSUM_FLAG = 'Y' THEN
205: DELETE FROM PAY_ACTION_INFORMATION

Line 205: DELETE FROM PAY_ACTION_INFORMATION

201: DELETE FROM PAY_ACTION_INFORMATION
202: WHERE ACTION_INFORMATION_CATEGORY = 'AU_EMPLOYEE_RECON_DETAILS'
203: AND ACTION_CONTEXT_ID = LP_PAYROLL_ACTION_ID;
204: IF P_PAYSUM_FLAG = 'Y' THEN
205: DELETE FROM PAY_ACTION_INFORMATION
206: WHERE ACTION_INFORMATION_CATEGORY in ( 'AU_ELEMENT_RECON_DETAILS' , 'AU_BALANCE_RECON_DETAILS_YTD' , 'AU_PS_BALANCE_RECON_DETAILS' )
207: AND ACTION_CONTEXT_ID in (
208: SELECT
209: PAA.ASSIGNMENT_ACTION_ID

Line 215: DELETE FROM PAY_ACTION_INFORMATION

211: PAY_ASSIGNMENT_ACTIONS PAA
212: WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID
213: AND PAA.ACTION_STATUS = 'C' );
214: ELSE
215: DELETE FROM PAY_ACTION_INFORMATION
216: WHERE ACTION_INFORMATION_CATEGORY in ( 'AU_ELEMENT_RECON_DETAILS' , 'AU_BALANCE_RECON_DETAILS_RUN' , 'AU_BALANCE_RECON_DETAILS_YTD' )
217: AND ACTION_CONTEXT_ID in (
218: SELECT
219: PAA.ASSIGNMENT_ACTION_ID

Line 224: DELETE FROM PAY_ACTION_INFORMATION

220: FROM
221: PAY_ASSIGNMENT_ACTIONS PAA
222: WHERE PAA.PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID
223: AND PAA.ACTION_STATUS = 'C' );
224: DELETE FROM PAY_ACTION_INFORMATION
225: WHERE ACTION_INFORMATION_CATEGORY = 'AU_ARCHIVE_ASG_DETAILS'
226: AND ACTION_INFORMATION2 = TO_CHAR(LP_PAYROLL_ACTION_ID);
227: END IF;
228: EXCEPTION