DBA Data[Home] [Help]

APPS.PA_HR_UPDATE_API dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4182: FUNCTION get_org_name(P_org_id IN hr_all_organization_units.organization_id%type)

4178: RAISE ;
4179:
4180: END ;
4181:
4182: FUNCTION get_org_name(P_org_id IN hr_all_organization_units.organization_id%type)
4183: RETURN hr_all_organization_units.name%type IS
4184: l_org_name varchar2(240);
4185:
4186: BEGIN

Line 4183: RETURN hr_all_organization_units.name%type IS

4179:
4180: END ;
4181:
4182: FUNCTION get_org_name(P_org_id IN hr_all_organization_units.organization_id%type)
4183: RETURN hr_all_organization_units.name%type IS
4184: l_org_name varchar2(240);
4185:
4186: BEGIN
4187:

Line 4190: FROM hr_all_organization_units_tl

4186: BEGIN
4187:
4188: SELECT name
4189: INTO l_org_name
4190: FROM hr_all_organization_units_tl
4191: WHERE organization_id = P_org_id
4192: AND language = USERENV('LANG');
4193:
4194: RETURN (l_org_name) ;