Line 228: FROM iby_transactions_v trn, iby_bepinfo ven
224: loc_order_id iby_trxn_summaries_all.Tangibleid%TYPE;
225:
226: CURSOR o1 IS
227: SELECT order_Id 228: FROM iby_transactions_v trn, iby_bepinfo ven 229: WHERE merchant_id = merchant_id_in
230: AND UPPER(ven.suffix) = UPPER(vendor_suffix)
231: AND ven.bepid = trn.vendor_id
232: AND status = 0