DBA Data[Home] [Help]

APPS.PQP_PERASGADD_RIW dependencies on HR_LOCATIONS_ALL_TL

Line 417: ,hr_locations_all_tl htl

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