2756: FROM po_system_parameters;
2757:
2758: SELECT hou.name
2759: INTO p_org_name
2760: FROM hr_all_organization_units hou,
2761: hr_all_organization_units_tl hout
2762: WHERE hou.organization_id = hout.organization_id
2763: AND hout.LANGUAGE = UserEnv('LANG')
2764: AND hou.organization_id = l_org_id;
2757:
2758: SELECT hou.name
2759: INTO p_org_name
2760: FROM hr_all_organization_units hou,
2761: hr_all_organization_units_tl hout
2762: WHERE hou.organization_id = hout.organization_id
2763: AND hout.LANGUAGE = UserEnv('LANG')
2764: AND hou.organization_id = l_org_id;
2765: