APPS.IBY_PAYMENT_ADAPTER_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 1220

         SELECT payerinstrid, instrtype
	 FROM iby_trxn_summaries_all
	 WHERE transactionid = ci_transactionid
	 AND   trxntypeid = 2
	 AND   status = 0;

Line: 1775

               SELECT NVL(instrtype, 'CREDITCARD')
               FROM   IBY_PAYMENTS_V
               WHERE  transactionid = p_canctrxn_rec.Trxn_ID;

Line: 2027

               SELECT NVL(instrtype, 'CREDITCARD')
               FROM   IBY_PAYMENTS_V
               WHERE  transactionid = p_querytrxn_rec.Trxn_ID;

Line: 3375

        	SELECT payeeid,
               	       payerid,
                       payerinstrid,
               	       tangibleid,
               	       amount,
               	       currencyNameCode,
               	       acctNo,
               	       refInfo,
               	       memo
          	 FROM  IBY_PAYMENTS_V
         	WHERE  ecappid = p_ecapp_id
           	  AND  transactionid = p_tid
             ORDER BY  payeeid, payerid, tangibleid;