APPS.HXT_HXT957A_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 8: SELECT HR_ALL_ORGANIZATION_UNITS_TL.NAME INTO

4: function ORG_NAMEFormula(ORGANIZATION_ID1 in number) return VARCHAR2 is
5: ORG_NAME VARCHAR2(60);
6: begin
7: ORG_NAME := '';
8: SELECT HR_ALL_ORGANIZATION_UNITS_TL.NAME INTO
9: ORG_NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE
10: (HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID=ORGANIZATION_ID1)
11: AND HR_ALL_ORGANIZATION_UNITS_TL.language = userenv('LANG');
12: RETURN ORG_NAME;

Line 9: ORG_NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE

5: ORG_NAME VARCHAR2(60);
6: begin
7: ORG_NAME := '';
8: SELECT HR_ALL_ORGANIZATION_UNITS_TL.NAME INTO
9: ORG_NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE
10: (HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID=ORGANIZATION_ID1)
11: AND HR_ALL_ORGANIZATION_UNITS_TL.language = userenv('LANG');
12: RETURN ORG_NAME;
13: RETURN NULL; EXCEPTION

Line 10: (HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID=ORGANIZATION_ID1)

6: begin
7: ORG_NAME := '';
8: SELECT HR_ALL_ORGANIZATION_UNITS_TL.NAME INTO
9: ORG_NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE
10: (HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID=ORGANIZATION_ID1)
11: AND HR_ALL_ORGANIZATION_UNITS_TL.language = userenv('LANG');
12: RETURN ORG_NAME;
13: RETURN NULL; EXCEPTION
14: when NO_DATA_FOUND then

Line 11: AND HR_ALL_ORGANIZATION_UNITS_TL.language = userenv('LANG');

7: ORG_NAME := '';
8: SELECT HR_ALL_ORGANIZATION_UNITS_TL.NAME INTO
9: ORG_NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE
10: (HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID=ORGANIZATION_ID1)
11: AND HR_ALL_ORGANIZATION_UNITS_TL.language = userenv('LANG');
12: RETURN ORG_NAME;
13: RETURN NULL; EXCEPTION
14: when NO_DATA_FOUND then
15: org_name := '';