APPS.PSP_PSPLDORG_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 92: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

88: RETURN 'ERROR';
89: END CF_TIME_PERIOD_NAMEFORMULA;
90:
91: FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2 IS
92: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
93: V_INSTITUTION_ID VARCHAR2(30);
94: BEGIN
95: V_INSTITUTION_ID := VALUE('PSP_ORG_REPORT');
96: IF V_INSTITUTION_ID IS NULL THEN

Line 133: EXP_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

129: PROJ_NAME VARCHAR2(25);
130: TASK_NAME VARCHAR2(25);
131: AWARD_NAME VARCHAR2(15);
132: EXP_TYPE VARCHAR2(100);
133: EXP_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
134: V_RETCODE NUMBER;
135: L_CHART_OF_ACCTS VARCHAR2(20);
136: BEGIN
137: IF GL_ID IS NOT NULL THEN