APPS.PSP_PSPLDDFA_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 88: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

84: RETURN (TRUE);
85: END P_TIME_PERIOD_ENDVALIDTRIGGER;
86:
87: FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2 IS
88: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
89: V_INSTITUTION_ID VARCHAR2(30);
90: BEGIN
91: V_INSTITUTION_ID := VALUE('PSP_ORG_REPORT');
92: IF V_INSTITUTION_ID IS NULL THEN

Line 178: V_ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

174: ,CF_CURRENCY_FORMAT));
175: END CF_SUM_DISTRIBUTION_AMOUNTFORM;
176:
177: FUNCTION CF_ORGANIZATION_NAMEFORMULA(ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2 IS
178: V_ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
179: BEGIN
180: SELECT
181: DISTINCT
182: NAME

Line 210: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

206: GL_FLEX_VALUES VARCHAR2(2000);
207: L_PROJECT_NAME VARCHAR2(30);
208: L_AWARD_NUMBER VARCHAR2(15);
209: L_TASK_NUMBER VARCHAR2(300); -- Bug : 16391366 (27/03/2013)
210: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
211: L_POETA VARCHAR2(2000);
212: BEGIN
213: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN
214: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(TO_NUMBER(P_SET_OF_BOOKS_ID)