[Home] [Help]
669: and upper(puc.county_name) = upper(cp_county_name);
670:
671: cursor c_get_city_code(cp_state_code in varchar2
672: ,cp_city_name in varchar2) is
673: select city_code from pay_us_city_names
674: where state_code = cp_state_code
675: and upper(city_name) = upper(cp_city_name);
676:
677: lv_state_code VARCHAR2(2);