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 261: CURSOR C_PAYMENT_SUMMARY_DETAILS(C_ASSIGNMENT_ID IN NUMBER,C_FIN_DATE IN DATE,C_TAX_UNIT_ID IN PAY_ASSIGNMENT_ACTIONS.TAX_UNIT_ID%TYPE) IS

257: L_MESSAGE VARCHAR2(100);
258: L_FBT_VALUE NUMBER;
259: X NUMBER;
260: L_MANUAL_PS_YEAR VARCHAR2(80);
261: CURSOR C_PAYMENT_SUMMARY_DETAILS(C_ASSIGNMENT_ID IN NUMBER,C_FIN_DATE IN DATE,C_TAX_UNIT_ID IN PAY_ASSIGNMENT_ACTIONS.TAX_UNIT_ID%TYPE) IS
262: SELECT
263: HR.MEANING FIN_YEAR
264: FROM
265: PER_ASSIGNMENT_EXTRA_INFO PAE,

Line 480: DELETE FROM PAY_ASSIGNMENT_ACTIONS

476: END CF_CALC_TOTALSFORMULA;
477:
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;

Line 496: PAY_ASSIGNMENT_ACTIONS PAA,

492: ,15
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

Line 509: L_ASSIGNMENT_ACTION_ID PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;

505: AND CP_FIN_YR_END
506: AND PAA.ACTION_STATUS = 'C'
507: AND PPA.ACTION_STATUS = 'C'
508: AND PPA.ACTION_TYPE in ( 'R' , 'Q' , 'I' , 'V' , 'B' );
509: L_ASSIGNMENT_ACTION_ID PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;
510: L_GROUP_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
511: L_GROUP_ASSGT_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
512: BEGIN
513: L_GROUP_OUTPUT_TAB.DELETE;