APPS.PSP_PSPENORG_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 62: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

58: GL_FLEX_VALUES VARCHAR2(2000);
59: L_PROJECT_NAME VARCHAR2(30);
60: L_AWARD_NUMBER VARCHAR2(15);
61: L_TASK_NUMBER VARCHAR2(25);
62: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
63: BEGIN
64: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN
65: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(TO_NUMBER(P_SET_OF_BOOKS_ID)
66: ,L_CHART_OF_ACCTS);

Line 95: HR_ALL_ORGANIZATION_UNITS

91: SELECT
92: NAME
93: INTO L_ORG_NAME
94: FROM
95: HR_ALL_ORGANIZATION_UNITS
96: WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID;
97: RETURN (L_PROJECT_NAME || ' ' || L_TASK_NUMBER || ' ' || L_AWARD_NUMBER || ' ' || L_ORG_NAME || ' ' || EXPENDITURE_TYPE);
98: END IF;
99: EXCEPTION