DBA Data[Home] [Help]

APPS.PAY_US_TAX_WF dependencies on PAY_US_STATES

Line 134: ,pay_us_states pus

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