333: SELECT hou.organization_id
334: ,houtl.name
335: ,hou.business_group_id
336: ,hou.location_id
337: FROM hr_all_organization_units hou,
338: hr_all_organization_units_tl houtl
339: WHERE hou.organization_id = p_organization_id
340: AND houtl.organization_id = hou.organization_id
341: AND houtl.language = USERENV('LANG');
334: ,houtl.name
335: ,hou.business_group_id
336: ,hou.location_id
337: FROM hr_all_organization_units hou,
338: hr_all_organization_units_tl houtl
339: WHERE hou.organization_id = p_organization_id
340: AND houtl.organization_id = hou.organization_id
341: AND houtl.language = USERENV('LANG');
342:
985: ,hou.location_id
986: INTO l_org_name
987: ,l_business_group_id
988: ,l_org_location_id
989: FROM hr_all_organization_units hou
990: WHERE hou.organization_id = l_organization_id;
991:
992: IF l_org_location_id IS NULL THEN
993: pa_debug.g_err_stage := l_stage||': Organization Id ['