APPS.PAY_PYAURECD_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 341: CURSOR GET_LEG_EMP_NAME(C_LEG_EMP_ID IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE) IS

337: END CF_EMP_DISPLAYFORMULA;
338:
339: FUNCTION CF_LEG_EMP_DISPLAYFORMULA RETURN CHAR IS
340: L_LEG_EMP_NAME VARCHAR2(80) := NULL;
341: CURSOR GET_LEG_EMP_NAME(C_LEG_EMP_ID IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE) IS
342: SELECT
343: SUBSTR(NAME
344: ,1
345: ,80)

Line 347: HR_ORGANIZATION_UNITS

343: SUBSTR(NAME
344: ,1
345: ,80)
346: FROM
347: HR_ORGANIZATION_UNITS
348: WHERE ORGANIZATION_ID = C_LEG_EMP_ID;
349: BEGIN
350: IF (LP_REGISTERED_EMPLOYER IS NOT NULL) THEN
351: OPEN GET_LEG_EMP_NAME(LP_REGISTERED_EMPLOYER);

Line 381: CURSOR GET_ORG_NAME(C_ORGANIZATION_ID IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE) IS

377: END CF_NO_DATA_END_REPORTFORMULA;
378:
379: FUNCTION CF_ORG_ID_DISPLAYFORMULA RETURN CHAR IS
380: L_ORG_NAME VARCHAR2(80) := NULL;
381: CURSOR GET_ORG_NAME(C_ORGANIZATION_ID IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE) IS
382: SELECT
383: SUBSTR(NAME
384: ,1
385: ,80)

Line 387: HR_ORGANIZATION_UNITS

383: SUBSTR(NAME
384: ,1
385: ,80)
386: FROM
387: HR_ORGANIZATION_UNITS
388: WHERE ORGANIZATION_ID = C_ORGANIZATION_ID;
389: BEGIN
390: IF (LP_ORGANIZATION_ID IS NOT NULL) THEN
391: OPEN GET_ORG_NAME(LP_ORGANIZATION_ID);