3054: -- State/County entered
3055:
3056: SELECT 'S'
3057: INTO v_valid_jurisdiction
3058: FROM PAY_US_COUNTIES
3059: WHERE STATE_CODE = substr(p_jurisdiction_code, 1,2)
3060: AND COUNTY_CODE = substr(p_jurisdiction_code, 4,3);
3061:
3062: END IF;
4854: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4855: INTO l_geocode
4856: FROM pay_us_zip_codes z,
4857: pay_us_city_names a,
4858: pay_us_counties b
4859: WHERE a.city_name = l_query_city_name
4860: AND a.county_code = b.county_code
4861: AND UPPER(b.county_name) = UPPER(p_county_name) --Bug3783309-Changed Initcap to Upper.
4862: AND b.state_code = l_state_code
4881: SELECT a.state_code||'-'||a.county_code||'-'||a.city_code
4882: INTO l_geocode
4883: FROM pay_us_zip_codes z,
4884: pay_us_city_names a,
4885: pay_us_counties b,
4886: pay_us_states c
4887: WHERE c.state_code = a.state_code AND
4888: c.state_abbrev = UPPER(p_state_abbrev)
4889: AND