APPS.PAY_PYAURECP_XMLP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 77: PAY_ASSIGNMENT_ACTIONS

73: CURSOR C_ASG_COUNT IS
74: SELECT
75: COUNT(ASSIGNMENT_ACTION_ID)
76: FROM
77: PAY_ASSIGNMENT_ACTIONS
78: WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
79: X NUMBER;
80: L_TEXT LONG;
81: LN NUMBER;

Line 280: C_TAX_UNIT_ID IN PAY_ASSIGNMENT_ACTIONS.TAX_UNIT_ID%TYPE)

276: L_MANUAL_PS_YEAR VARCHAR2(80);
277:
278: CURSOR C_PAYMENT_SUMMARY_DETAILS(C_ASSIGNMENT_ID IN NUMBER,
279: C_FIN_DATE IN DATE,
280: C_TAX_UNIT_ID IN PAY_ASSIGNMENT_ACTIONS.TAX_UNIT_ID%TYPE)
281: IS
282: SELECT HR.MEANING FIN_YEAR
283: FROM PER_ASSIGNMENT_EXTRA_INFO PAE,
284: HR_LOOKUPS HR

Line 300: FROM PAY_ASSIGNMENT_ACTIONS PAA

296: C_YEAR_START IN DATE,
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

Line 315: CURSOR GET_EFFECTIVE_DATE(C_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)

311: AND PAA.ACTION_STATUS='C'
312: AND PAA.TAX_UNIT_ID = C_TAX_UNIT_ID;
313:
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

Line 319: ,PAY_ASSIGNMENT_ACTIONS PAA

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
323: OPEN C_PAYMENT_SUMMARY_DETAILS(ASSIGNMENT_ID,CP_FIN_YR_START,TAX_UNIT_ID);

Line 590: DELETE FROM PAY_ASSIGNMENT_ACTIONS

586: END CF_CALC_TOTALSFORMULA;
587:
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;

Line 602: FROM PAY_ASSIGNMENT_ACTIONS PAA,

598: FUNCTION CF_CALC_GROUP_TOTALSFORMULA RETURN NUMBER IS
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)

Line 613: L_ASSIGNMENT_ACTION_ID PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;

609: AND PAA.ACTION_STATUS = 'C'
610: AND PPA.ACTION_STATUS = 'C'
611: AND PPA.ACTION_TYPE in ( 'R' , 'Q' , 'I' , 'V' , 'B' );
612:
613: L_ASSIGNMENT_ACTION_ID PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;
614: L_GROUP_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
615: L_GROUP_ASSGT_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
616:
617: BEGIN