APPS.AR_CC_REFUNDS SQL Statements

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

Line: 102

        SELECT DISTINCT transactionid
         FROM iby_trans_all_v
        WHERE tangibleid = cc_pay_server_order_num;

Line: 109

        SELECT DISTINCT tangibleid
        FROM iby_trans_all_v
        WHERE trxnref = cc_unique_reference
        AND reqtype = 'ORAPMTCREDIT';

Line: 256

            SELECT 'AR_'||ar_payment_server_ord_num_s.nextval
            INTO cc_pay_server_order_num
            FROM DUAL;