APPS.PSP_PSPLDPRJ_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 54: HR_ORGANIZATION_UNITS

50: DISTINCT
51: NAME
52: INTO V_INSTITUTION_NAME
53: FROM
54: HR_ORGANIZATION_UNITS
55: WHERE ORGANIZATION_ID = TO_NUMBER(V_INSTITUTION_ID);
56: RETURN V_INSTITUTION_NAME;
57: RETURN NULL;
58: EXCEPTION

Line 238: L_EXP_ORG HR_ORGANIZATION_UNITS.NAME%TYPE;

234: ,CF_PROJECT_NAME IN VARCHAR2
235: ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR IS
236: L_AWARD_NUMBER GMS_AWARDS_ALL.AWARD_NUMBER%TYPE;
237: L_TASK_NUMBER VARCHAR(300); -- PA_TASKS.TASK_NUMBER%TYPE -- Bug 16391366 (27/03/2013)
238: L_EXP_ORG HR_ORGANIZATION_UNITS.NAME%TYPE;
239: BEGIN
240: IF EXPENDITURE_ORGANIZATION_ID IS NOT NULL THEN
241: SELECT
242: NAME