The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(*)
INTO num_trxns
FROM iby_batches_all
WHERE BatchID = order_id_in;
SELECT BatchStatus
INTO status_out
FROM iby_batches_all
WHERE BatchID = order_id_in;
SELECT count(*)
INTO num_trxns
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type IN (2)
AND split_id = split_id_in
AND (request_type IN (2,4)
OR
request_type IS NULL)
AND status = 0;
SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
INTO prev_set_trxn_id_in_out,price_out,currency_out
FROM iby_transactions_set_v TRX
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type IN (2)
AND split_id = split_id_in
AND (request_type IN (2,4)
OR
request_type IS NULL)
AND status = 0;
SELECT count(*)
INTO num_trxns
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type IN (2,4,101) -- auth, authrev, or subsequentauth
AND split_id = split_id_in
AND (request_type IN (2,4)
OR
request_type IS NULL)
AND status = 0;
SELECT count(*)
INTO num_trxns
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type = 4 -- authrev
AND split_id = split_id_in
AND (request_type IN (2,4)
OR
request_type IS NULL)
AND status = 0;
SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
INTO prev_set_trxn_id_in_out,price_out,currency_out
FROM iby_transactions_set_v TRX
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type = 4 --authrev
AND split_id = split_id_in
AND (request_type IN (2,4)
OR
request_type IS NULL)
AND status = 0;
SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
INTO prev_set_trxn_id_in_out,price_out,currency_out
FROM iby_transactions_set_v TRX
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type IN (2, 4, 101)
AND split_id = split_id_in
AND (request_type IN (2,4)
OR
request_type IS NULL)
AND status = 0;
SELECT count(*)
INTO num_trxns
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND ( trxn_type IN (8, 9)
OR
(trxn_type = 3 AND request_type IN (2,4)))
AND split_id = split_id_in;
SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
INTO prev_set_trxn_id_in_out,price_out,currency_out
FROM iby_transactions_set_v TRX
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND ( trxn_type IN (8, 9)
OR
(trxn_type = 3 AND request_type IN (2,4)))
AND split_id = split_id_in;
SELECT count(*)
INTO num_trxns
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type = 5
AND split_id = split_id_in;
SELECT TRX.set_trxn_id, TRX.amount, TRX.currency
INTO prev_set_trxn_id_in_out,price_out,currency_out
FROM iby_transactions_set_v TRX
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type = 5
AND split_id = split_id_in;
SELECT ROUT.bepid , BEP.baseurl, BEP.suffix
INTO v_id, v_base_url, v_suffix
FROM iby_bepinfo BEP, iby_routinginfo ROUT
WHERE UPPER(ROUT.paymentmethodname) = UPPER(payment_name_in)
AND BEP.bepid = ROUT.bepid
AND ROUT.configured = 1;
SELECT status
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type IN (tx1, tx2)
AND split_id = split_id_in
ORDER BY time DESC;
SELECT count(*)
INTO num_trxns
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type in (2,3)
AND request_type = 2;
SELECT status
INTO loc_status
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type in (2,3)
AND request_type = 2
ORDER BY TIME DESC;
SELECT amount,currency
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type IN (tx1, tx2)
AND split_id = split_id_in
ORDER BY time DESC;
SELECT count(*)
INTO num_trxns
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type in (2,3)
AND request_type = 2;
SELECT amount,currency
INTO price_out, currency_out
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND trxn_type in (2,3)
AND request_type = 2
ORDER BY TIME DESC;
SELECT count(*)
INTO num_trxns
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND split_id = split_id_in
AND trxn_type = 101;
SELECT status
INTO status_out
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND split_id = split_id_in
AND trxn_type = 101;
SELECT count(*)
INTO num_trxns
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND split_id = prev_split_id_in
AND trxn_type IN (2, 101)
AND (request_type IN (2,4)
OR
request_type IS NULL)
AND status = 0;
SELECT set_trxn_id, subseq_auth_ind
INTO set_trxn_id_out, auth_ind
FROM iby_transactions_set_v
WHERE order_id = order_id_in
AND merchant_id = merchant_id_in
AND split_id = prev_split_id_in
AND trxn_type IN (2,101)
AND (request_type IN (2,4)
OR
request_type IS NULL)
AND status = 0;