APPS.ZX_TAXWARE_USER_PKG dependencies on HZ_LOCATIONS

Line 1790: FROM hz_locations loc

1786: THEN
1787: BEGIN
1788: SELECT decode(nvl(loc.sales_tax_inside_city_limits,'1'),'0','0','1') || loc.sales_tax_geocode
1789: INTO arp_ship_to_add_tab(i)
1790: FROM hz_locations loc
1791: WHERE loc.location_id = nvl(ship_to_loc_id_tab(i), bill_to_location_id_tab(i));
1792: EXCEPTION WHEN OTHERS THEN
1793: arp_ship_to_add_tab(i) := NULL;
1794: END;

Line 1826: FROM HZ_LOCATIONS

1822: IF l_jurisdictions_found = 'N' OR (l_jurisdictions_found = 'Y' AND l_tax_jurisdiction_rec.tax_jurisdiction_code IS NULL) THEN
1823: BEGIN
1824: SELECT state, substr(postal_code,1,5)
1825: INTO l_state_code, l_postal_code
1826: FROM HZ_LOCATIONS
1827: WHERE location_id = NVL(ship_to_loc_id_tab(i), bill_to_location_id_tab(i));
1828: EXCEPTION
1829: WHEN OTHERS THEN
1830: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN