412: ,c_business_group_id in number
413: ) is
414: select htl.location_code
415: from hr_locations hrl
416: ,hr_locations_all_tl htl
417: where hrl.location_id = c_location_id
418: and htl.location_id = hrl.location_id
419: and htl.language = Userenv('LANG')
420: and (hrl.business_group_id is null or