APPS.ZX_VTX_USER_PKG dependencies on HZ_LOCATIONS

Line 1879: FROM hz_locations loc

1875: SELECT decode(nvl(loc.sales_tax_inside_city_limits,'1'),'0','0','1') || loc.sales_tax_geocode
1876: , decode(nvl(loc.sales_tax_inside_city_limits,'1'),'0','0','1')
1877: INTO arp_ship_to_add_tab(i)
1878: , l_in_out_flag -- Bug 5506031
1879: FROM hz_locations loc
1880: WHERE loc.location_id = nvl(ship_to_loc_id_tab(i), bill_to_location_id_tab(i));
1881: EXCEPTION WHEN OTHERS THEN
1882: arp_ship_to_add_tab(i) := NULL;
1883: END;