518: BEGIN
519: SELECT loc.location_code, hou1.name, loc.location_id
520: INTO l_location_code, l_business_group_name, l_location_id
521: FROM hr_locations loc
522: , hr_all_organization_units hou
523: , hr_all_organization_units hou1
524: WHERE loc.location_id = hou.location_id
525: AND hou1.organization_id = hou.business_group_id
526: AND hou.organization_id = g_model_org_id;
519: SELECT loc.location_code, hou1.name, loc.location_id
520: INTO l_location_code, l_business_group_name, l_location_id
521: FROM hr_locations loc
522: , hr_all_organization_units hou
523: , hr_all_organization_units hou1
524: WHERE loc.location_id = hou.location_id
525: AND hou1.organization_id = hou.business_group_id
526: AND hou.organization_id = g_model_org_id;
527: EXCEPTION
540: BEGIN
541: SELECT loc.location_code, hou1.name, loc.location_id
542: INTO l_location_code, l_business_group_name, l_location_id
543: FROM hr_locations loc
544: , hr_all_organization_units hou
545: , hr_all_organization_units hou1
546: WHERE loc.location_id = hou.location_id
547: AND hou1.organization_id = hou.business_group_id
548: AND hou.organization_id = g_organization_id;
541: SELECT loc.location_code, hou1.name, loc.location_id
542: INTO l_location_code, l_business_group_name, l_location_id
543: FROM hr_locations loc
544: , hr_all_organization_units hou
545: , hr_all_organization_units hou1
546: WHERE loc.location_id = hou.location_id
547: AND hou1.organization_id = hou.business_group_id
548: AND hou.organization_id = g_organization_id;
549: EXCEPTION