APPS.PAY_PYAURECP_XMLP_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 301: , PAY_PAYROLL_ACTIONS PPA

297: C_YEAR_END IN DATE )
298: IS
299: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(PAA.ACTION_SEQUENCE,15,'0')||PAA.ASSIGNMENT_ACTION_ID),16)) ASSIGNMENT_ACTION_ID
300: FROM PAY_ASSIGNMENT_ACTIONS PAA
301: , PAY_PAYROLL_ACTIONS PPA
302: , PER_ASSIGNMENTS_F PAF
303: WHERE PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
304: AND PAF.ASSIGNMENT_ID = C_ASSIGNMENT_ID
305: AND PAA.ASSIGNMENT_ID = C_ASSIGNMENT_ID

Line 318: FROM PAY_PAYROLL_ACTIONS PPA

314:
315: CURSOR GET_EFFECTIVE_DATE(C_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
316: IS
317: SELECT PPA.EFFECTIVE_DATE
318: FROM PAY_PAYROLL_ACTIONS PPA
319: ,PAY_ASSIGNMENT_ACTIONS PAA
320: WHERE PAA.ASSIGNMENT_ACTION_ID = C_ASSIGNMENT_ACTION_ID
321: AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID;
322: BEGIN

Line 592: DELETE FROM PAY_PAYROLL_ACTIONS

588: FUNCTION AFTERREPORT RETURN BOOLEAN IS
589: BEGIN
590: DELETE FROM PAY_ASSIGNMENT_ACTIONS
591: WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
592: DELETE FROM PAY_PAYROLL_ACTIONS
593: WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
594: COMMIT;
595: RETURN (TRUE);
596: END AFTERREPORT;

Line 603: PAY_PAYROLL_ACTIONS PPA

599: CURSOR CSR_MAX_ASSGT_ACTION
600: IS
601: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(PAA.ACTION_SEQUENCE ,15,'0') || PAA.ASSIGNMENT_ACTION_ID),16)) ASSIGNMENT_ACTION_ID
602: FROM PAY_ASSIGNMENT_ACTIONS PAA,
603: PAY_PAYROLL_ACTIONS PPA
604: WHERE PAA.TAX_UNIT_ID = LP_REGISTERED_EMPLOYER
605: AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
606: AND PPA.PAYROLL_ID = NVL(LP_PAYROLL_ID,PPA.PAYROLL_ID)
607: AND PAA.ASSIGNMENT_ID = NVL(LP_ASSIGNMENT_ID,PAA.ASSIGNMENT_ID)