The following lines contain the word 'select', 'insert', 'update' or 'delete':
select state_abbrev,state_code
from pay_us_states
where state_code <= '51';
select state_abbrev
from pay_us_states
where state_code <= '51';
select city_name
from pay_us_city_names
where state_code = cp_state_code
and city_code = cp_city_code
and primary_flag = 'Y';
select county_name
from pay_us_counties
where state_code = cp_state_code
and county_code = cp_county_code;
SELECT nvl(status,'Y')
FROM pay_taxability_rules
where tax_type = cp_tax_type
and tax_category = cp_tax_category
and classification_id = cp_classification_id
and jurisdiction_code = cp_jurisdiction_code
and legislation_code = cp_legislation_code;