APPS.PA_HR_UPDATE_API dependencies on HR_ALL_ORGANIZATION_UNITS

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

4317: RAISE ;
4318:
4319: END ;
4320:
4321: FUNCTION get_org_name(P_org_id IN hr_all_organization_units.organization_id%type)
4322: RETURN hr_all_organization_units.name%type IS
4323: l_org_name varchar2(240);
4324:
4325: BEGIN

Line 4322: RETURN hr_all_organization_units.name%type IS

4318:
4319: END ;
4320:
4321: FUNCTION get_org_name(P_org_id IN hr_all_organization_units.organization_id%type)
4322: RETURN hr_all_organization_units.name%type IS
4323: l_org_name varchar2(240);
4324:
4325: BEGIN
4326:

Line 4329: FROM hr_all_organization_units_tl

4325: BEGIN
4326:
4327: SELECT name
4328: INTO l_org_name
4329: FROM hr_all_organization_units_tl
4330: WHERE organization_id = P_org_id
4331: AND language = USERENV('LANG');
4332:
4333: RETURN (l_org_name) ;