[Home] [Help]
1892: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
1893:
1894: CURSOR county_exists is
1895: SELECT county_tax
1896: FROM pay_us_county_tax_info_f
1897: WHERE jurisdiction_code = substr(p_jd_code, 1, 7)||'0000'
1898: AND p_adj_date BETWEEN effective_start_date AND effective_end_date;
1899:
1900: CURSOR city_exists is