APPS.PSP_PSPLDAWD_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 51: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

47: RETURN 'ERROR';
48: END CF_EMPLOYEE_NUMBERFORMULA;
49:
50: FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2 IS
51: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
52: V_INSTITUTION_ID VARCHAR2(30);
53: BEGIN
54: V_INSTITUTION_ID := VALUE('PSP_ORG_REPORT');
55: IF V_INSTITUTION_ID IS NULL THEN

Line 249: HR_ALL_ORGANIZATION_UNITS

245: SELECT
246: NAME
247: INTO L_EXP_ORG
248: FROM
249: HR_ALL_ORGANIZATION_UNITS
250: WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID
251: AND ROWNUM = 1;
252: ELSE
253: L_EXP_ORG := '';