APPS.IBY_PAYMENT_ADAPTER_PUB SQL Statements

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

Line: 1456

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

Line: 1708

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

Line: 3054

        	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;