APPS.PSP_PSPENAWD_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 58: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

54: ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR IS
55: L_PROJECT_NAME VARCHAR2(30);
56: L_AWARD_NUMBER VARCHAR2(15);
57: L_TASK_NUMBER VARCHAR2(25);
58: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
59: BEGIN
60: SELECT
61: NAME
62: INTO L_PROJECT_NAME

Line 82: HR_ALL_ORGANIZATION_UNITS

78: SELECT
79: NAME
80: INTO L_ORG_NAME
81: FROM
82: HR_ALL_ORGANIZATION_UNITS
83: WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID;
84: RETURN (L_PROJECT_NAME || ' ' || L_TASK_NUMBER || ' ' || L_AWARD_NUMBER || ' ' || L_ORG_NAME || ' ' || EXPENDITURE_TYPE);
85: EXCEPTION
86: WHEN NO_DATA_FOUND THEN