APPS.IBY_QUERYCC_PKG dependencies on IBY_TRANSACTIONS_V

Line 53: loc_status iby_transactions_v.status%TYPE;

49: )
50:
51: IS
52:
53: loc_status iby_transactions_v.status%TYPE;
54:
55: CURSOR s1(i_reqtype1 iby_trxn_summaries_all.reqtype%type,
56: i_reqtype2 iby_trxn_summaries_all.reqtype%type DEFAULT
57: NULL)

Line 71: FROM iby_transactions_v

67:
68: CURSOR s2(tx1 NUMBER,
69: tx2 NUMBER DEFAULT NULL) IS
70: SELECT tracenumber
71: FROM iby_transactions_v
72: WHERE order_Id = order_id_in
73: AND merchant_id = merchant_id_in
74: AND trxn_type IN (tx1, tx2)
75: ORDER BY time DESC;

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