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;
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)