SELECT tax ,tax_jurisdiction_code ,geography_element2_code state_code ,geography_element3_code county_code ,geography_element4_code city_code FROM zx_jurisdictions_b tax_juridiction ,hz_geographies geography WHERE tax_juridiction.tax_regime_code = '<<tax_regime_code>>' AND SYSDATE BETWEEN tax_juridiction.effective_from AND NVL(tax_juridiction.effective_to,'31-dec-4999') AND tax_juridiction.zone_geography_id=geography.geography_id AND tax_juridiction.tax = geography.geography_type AND SYSDATE BETWEEN geography.start_date AND geography.end_date AND NOT EXISTS (SELECT 1 FROM zx_rates_b zr WHERE zr.tax_regime_code='<<tax_regime_code>>' AND zr.tax_jurisdiction_code = tax_juridiction.tax_jurisdiction_code ) ORDER BY tax ,tax_jurisdiction_code ,geography_element2_code ,geography_element3_code
,geography_element4_code
No comments:
Post a Comment