130:
131: CURSOR c_state_list IS
132: select pus.state_name
133: from pay_stat_trans_audit pta 134: ,pay_us_states pus 135: where pta.transaction_parent_id = ln_transaction_id
136: and pus.state_code = substr(pta.source1,1,2)
137: and exists(select 'x' from pay_us_state_tax_info_f stif
138: where stif.state_code = pus.state_code