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 2007/10/29 07:22:34 amakrish noship $ */
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