100: FROM po_system_parameters;
101:
102: SELECT hou.name
103: INTO p_org_name
104: FROM hr_all_organization_units hou,
105: hr_all_organization_units_tl hout
106: WHERE hou.organization_id = hout.organization_id
107: AND hout.LANGUAGE = UserEnv('LANG')
108: AND hou.organization_id = l_org_id;
101:
102: SELECT hou.name
103: INTO p_org_name
104: FROM hr_all_organization_units hou,
105: hr_all_organization_units_tl hout
106: WHERE hou.organization_id = hout.organization_id
107: AND hout.LANGUAGE = UserEnv('LANG')
108: AND hou.organization_id = l_org_id;
109: