APPS.ZX_VTX_USER_PKG dependencies on HZ_LOCATIONS

Line 1733: FROM hz_locations loc

1729: SELECT decode(nvl(loc.sales_tax_inside_city_limits,'1'),'0','0','1') || loc.sales_tax_geocode
1730: , decode(nvl(loc.sales_tax_inside_city_limits,'1'),'0','0','1')
1731: INTO arp_ship_to_add_tab(i)
1732: , l_in_out_flag -- Bug 5506031
1733: FROM hz_locations loc
1734: WHERE loc.location_id = nvl(ship_to_loc_id_tab(i), bill_to_location_id_tab(i));
1735: EXCEPTION WHEN OTHERS THEN
1736: arp_ship_to_add_tab(i) := NULL;
1737: END;