DBA Data[Home] [Help]

APPS.FND_ACCESS_CONTROL_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 19: l_return hr_all_organization_units_tl.name%TYPE;

15: --
16: FUNCTION Get_Org_Name( p_org_id NUMBER )
17: RETURN VARCHAR2
18: IS
19: l_return hr_all_organization_units_tl.name%TYPE;
20: BEGIN
21:
22: BEGIN
23: SELECT name

Line 25: FROM hr_all_organization_units_tl

21:
22: BEGIN
23: SELECT name
24: INTO l_return
25: FROM hr_all_organization_units_tl
26: WHERE organization_id = p_org_id
27: AND language = userenv('LANG');
28:
29: /* Commented out the following lines of code since exception