DBA Data[Home] [Help]

APPS.PAY_PYAURECD_XMLP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 211: PAY_ASSIGNMENT_ACTIONS PAA

207: AND ACTION_CONTEXT_ID in (
208: SELECT
209: PAA.ASSIGNMENT_ACTION_ID
210: FROM
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

Line 221: PAY_ASSIGNMENT_ACTIONS PAA

217: AND ACTION_CONTEXT_ID in (
218: SELECT
219: PAA.ASSIGNMENT_ACTION_ID
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'

Line 233: DELETE FROM PAY_ASSIGNMENT_ACTIONS PAA

229: WHEN OTHERS THEN
230: NULL;
231: END;
232: BEGIN
233: DELETE FROM PAY_ASSIGNMENT_ACTIONS PAA
234: WHERE PAA.PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
235: DELETE FROM PAY_PAYROLL_ACTIONS PPA
236: WHERE PPA.PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
237: EXCEPTION