345: ,c_business_group_id IN Number
346: ) IS
347: SELECT htl.location_code
348: FROM hr_locations hrl
349: ,hr_locations_all_tl htl
350: WHERE hrl.location_id = c_location_id
351: AND htl.location_id = hrl.location_id
352: AND htl.LANGUAGE = Userenv('LANG')
353: AND (hrl.business_group_id IS NULL OR