APPS.PSP_PSPLDAWD_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 63: HR_ORGANIZATION_UNITS

59: DISTINCT
60: NAME
61: INTO V_INSTITUTION_NAME
62: FROM
63: HR_ORGANIZATION_UNITS
64: WHERE ORGANIZATION_ID = TO_NUMBER(V_INSTITUTION_ID);
65: RETURN V_INSTITUTION_NAME;
66: RETURN NULL;
67: EXCEPTION

Line 235: L_EXP_ORG HR_ORGANIZATION_UNITS.NAME%TYPE;

231: ,AWARD_ID IN VARCHAR2
232: ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR IS
233: L_PROJECT_NUMBER PA_PROJECTS_ALL.SEGMENT1%TYPE;
234: L_TASK_NUMBER VARCHAR2(300); -- PA_TASKS.TASK_NUMBER%TYPE; -- Bug :16391366 (27/03/2013)
235: L_EXP_ORG HR_ORGANIZATION_UNITS.NAME%TYPE;
236: V_AWARD_NAME VARCHAR2(50);
237: BEGIN
238: SELECT
239: AWARD_NUMBER