APPS.ZX_TAXWARE_USER_PKG dependencies on HZ_LOCATIONS

Line 1942: FROM hz_locations loc

1938: THEN
1939: BEGIN
1940: SELECT decode(nvl(loc.sales_tax_inside_city_limits,'1'),'0','0','1') || loc.sales_tax_geocode
1941: INTO arp_ship_to_add_tab(i)
1942: FROM hz_locations loc
1943: WHERE loc.location_id = nvl(ship_to_loc_id_tab(i), bill_to_location_id_tab(i));
1944: EXCEPTION WHEN OTHERS THEN
1945: arp_ship_to_add_tab(i) := NULL;
1946: END;

Line 1978: FROM HZ_LOCATIONS

1974: IF l_jurisdictions_found = 'N' OR (l_jurisdictions_found = 'Y' AND l_tax_jurisdiction_rec.tax_jurisdiction_code IS NULL) THEN
1975: BEGIN
1976: SELECT state, substr(postal_code,1,5)
1977: INTO l_state_code, l_postal_code
1978: FROM HZ_LOCATIONS
1979: WHERE location_id = NVL(ship_to_loc_id_tab(i), bill_to_location_id_tab(i));
1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN