APPS.PAY_PYAURECD_XMLP_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 402: CURSOR GET_PAYROLL_NAME(C_PAYROLL_ID IN PAY_ALL_PAYROLLS_F.PAYROLL_ID%TYPE) IS

398: END CF_ORG_ID_DISPLAYFORMULA;
399:
400: FUNCTION CF_PAYROLL_NAMEFORMULA RETURN VARCHAR2 IS
401: L_PAYROLL_NAME VARCHAR2(80) := NULL;
402: CURSOR GET_PAYROLL_NAME(C_PAYROLL_ID IN PAY_ALL_PAYROLLS_F.PAYROLL_ID%TYPE) IS
403: SELECT
404: SUBSTR(PAYROLL_NAME
405: ,1
406: ,80)

Line 408: PAY_ALL_PAYROLLS_F

404: SUBSTR(PAYROLL_NAME
405: ,1
406: ,80)
407: FROM
408: PAY_ALL_PAYROLLS_F
409: WHERE PAYROLL_ID = C_PAYROLL_ID;
410: BEGIN
411: IF (LP_PAYROLL_ID IS NOT NULL) THEN
412: OPEN GET_PAYROLL_NAME(LP_PAYROLL_ID);

Line 429: PAY_ALL_PAYROLLS_F PAP,

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