APPS.PAY_PYAURECD_XMLP_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 235: DELETE FROM PAY_PAYROLL_ACTIONS PPA

231: END;
232: BEGIN
233: DELETE FROM PAY_ASSIGNMENT_ACTIONS PAA
234: WHERE PAA.PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
235: DELETE FROM PAY_PAYROLL_ACTIONS PPA
236: WHERE PPA.PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
237: EXCEPTION
238: WHEN OTHERS THEN
239: NULL;

Line 423: CURSOR PAYROLL_RUN(C_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS

419: END CF_PAYROLL_NAMEFORMULA;
420:
421: FUNCTION CF_PAYROLL_RUN_DISPLAYFORMUL RETURN CHAR IS
422: L_PAYROLL_RUN VARCHAR2(80) := NULL;
423: CURSOR PAYROLL_RUN(C_PAYROLL_ACTION_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS
424: SELECT
425: SUBSTR(PAP.PAYROLL_NAME
426: ,1
427: ,71 - LENGTH(PTP.PERIOD_NAME) - LENGTH(HRL.MEANING)) || ' - ' || PTP.PERIOD_NAME || ' (' || HRL.MEANING || ' ' || TO_CHAR(PPA.DISPLAY_RUN_NUMBER) || ')' DISPLAY

Line 431: PAY_PAYROLL_ACTIONS PPA,

427: ,71 - LENGTH(PTP.PERIOD_NAME) - LENGTH(HRL.MEANING)) || ' - ' || PTP.PERIOD_NAME || ' (' || HRL.MEANING || ' ' || TO_CHAR(PPA.DISPLAY_RUN_NUMBER) || ')' DISPLAY
428: FROM
429: PAY_ALL_PAYROLLS_F PAP,
430: PER_TIME_PERIODS PTP,
431: PAY_PAYROLL_ACTIONS PPA,
432: HR_LOOKUPS HRL
433: WHERE PPA.PAYROLL_ACTION_ID = C_PAYROLL_ACTION_ID
434: AND PAP.PAYROLL_ID = PPA.PAYROLL_ID
435: AND PAP.PAYROLL_ID = PTP.PAYROLL_ID