APPS.CSP_PART_SEARCH_PVT dependencies on HR_LOCATIONS

Line 2019: from hr_locations

2015: where location_id = p_location_id
2016: and p_location_source = 'HZ'
2017: union all
2018: select postal_code,town_or_city,upper(region_1),country,-9999
2019: from hr_locations
2020: where location_id = p_location_id
2021: and p_location_source = 'HR';
2022:
2023: cursor c_get_hz_loc is