DBA Data[Home] [Help]

APPS.PAY_US_TAX_WF dependencies on PAY_US_STATE_TAX_INFO_F

Line 137: and exists(select 'x' from pay_us_state_tax_info_f stif

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
139: and stif.sta_information7 = 'Y'
140: and pta.transaction_effective_date between
141: stif.effective_start_date and