APPS.PSP_PSPLDPRJ_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 42: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

38: RETURN (TRUE);
39: END BEFOREPFORM;
40:
41: FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2 IS
42: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
43: V_INSTITUTION_ID VARCHAR2(30);
44: BEGIN
45: V_INSTITUTION_ID := VALUE('PSP_ORG_REPORT');
46: IF V_INSTITUTION_ID IS NULL THEN

Line 245: HR_ALL_ORGANIZATION_UNITS

241: SELECT
242: NAME
243: INTO L_EXP_ORG
244: FROM
245: HR_ALL_ORGANIZATION_UNITS
246: WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID
247: AND ROWNUM = 1;
248: ELSE
249: L_EXP_ORG := '';