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