[Home] [Help]
180: FROM ecx_ext_processes
181: WHERE direction = 'OUT'
182: AND transaction_id IN
183: ( SELECT transaction_id
184: FROM ecx_transactions
185: WHERE transaction_type=l_trans_type
186: AND transaction_subtype =l_trans_subtype
187: )
188: )