APPS.PSP_PSPENCSC_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 4: V_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

1: PACKAGE BODY PSP_PSPENCSC_XMLP_PKG AS
2: /* $Header: PSPENCSCB.pls 120.3.12020000.2 2013/04/05 07:19:13 lkodaman ship $ */
3: FUNCTION SUSP_ORGANIZATIONFORMULA(SUSPENSE_ORG_ACCOUNT_ID IN NUMBER) RETURN VARCHAR2 IS
4: V_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
5: BEGIN
6: SELECT
7: NAME
8: INTO V_NAME

Line 98: V_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

94: RETURN ('error');
95: END CF_PROJECT_NUMBERFORMULA;
96:
97: FUNCTION CF_ORG_NAMEFORMULA(EXPENDITURE_ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2 IS
98: V_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
99: BEGIN
100: IF EXPENDITURE_ORGANIZATION_ID IS NOT NULL THEN
101: SELECT
102: NAME