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