DBA Data[Home] [Help]

APPS.PAY_PYAURECP_XMLP_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 482: DELETE FROM PAY_PAYROLL_ACTIONS

478: FUNCTION AFTERREPORT RETURN BOOLEAN IS
479: BEGIN
480: DELETE FROM PAY_ASSIGNMENT_ACTIONS
481: WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
482: DELETE FROM PAY_PAYROLL_ACTIONS
483: WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
484: COMMIT;
485: RETURN (TRUE);
486: END AFTERREPORT;

Line 497: PAY_PAYROLL_ACTIONS PPA

493: ,'0') || PAA.ASSIGNMENT_ACTION_ID)
494: ,16)) ASSIGNMENT_ACTION_ID
495: FROM
496: PAY_ASSIGNMENT_ACTIONS PAA,
497: PAY_PAYROLL_ACTIONS PPA
498: WHERE PAA.TAX_UNIT_ID = LP_REGISTERED_EMPLOYER
499: AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
500: AND PPA.PAYROLL_ID = NVL(LP_PAYROLL_ID
501: ,PPA.PAYROLL_ID)