[Home] [Help]
2267: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2268:
2269: CURSOR county_exists is
2270: SELECT county_tax
2271: FROM pay_us_county_tax_info_f
2272: WHERE jurisdiction_code = substr(p_jd_code, 1, 7)||'0000'
2273: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
2274:
2275: CURSOR city_exists is