171: from pay_stat_trans_audit pta
172: ,pay_us_states pus
173: where pta.source4 = ln_transaction_id
174: and pus.state_code = substr(pta.source1,1,2)
175: and exists(select 'x' from pay_us_state_tax_info_f stif
176: where stif.state_code = pus.state_code
177: and stif.sta_information7 = 'Y'
178: and stif.sta_information9 = 'Y'
179: and pta.transaction_effective_date between
186: from pay_stat_trans_audit pta
187: ,pay_us_states pus
188: where pta.source4 = ln_transaction_id
189: and pus.state_code = substr(pta.source1,1,2)
190: and exists(select 'x' from pay_us_state_tax_info_f stif
191: where stif.state_code = pus.state_code
192: and stif.sta_information7 = 'Y'
193: and stif.sta_information9 is null
194: and pta.transaction_effective_date between