2877: FROM po_system_parameters;
2878:
2879: SELECT hou.name
2880: INTO p_org_name
2881: FROM hr_all_organization_units hou,
2882: hr_all_organization_units_tl hout
2883: WHERE hou.organization_id = hout.organization_id
2884: AND hout.LANGUAGE = UserEnv('LANG')
2885: AND hou.organization_id = l_org_id;
2878:
2879: SELECT hou.name
2880: INTO p_org_name
2881: FROM hr_all_organization_units hou,
2882: hr_all_organization_units_tl hout
2883: WHERE hou.organization_id = hout.organization_id
2884: AND hout.LANGUAGE = UserEnv('LANG')
2885: AND hou.organization_id = l_org_id;
2886: