APPS.POS_BATCH_IMPORT_PKG dependencies on HR_LOCATIONS

Line 6481: FROM hr_locations loc

6477: ' Validating Tax registration address');
6478: BEGIN
6479: SELECT loc.location_id
6480: INTO l_dummy_location
6481: FROM hr_locations loc
6482: WHERE loc.location_code || ':' || ' ' || loc.address_line_1 || ' ' ||
6483: loc.town_or_city || ' ' || loc.region_1 =
6484: p_tax_reg_rec.registration_address
6485: AND legal_address_flag = 'Y'