APPS.AR_PUBLIC_UTILS SQL Statements

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

Line: 63

                SELECT *
                FROM   ar_receivable_applications
                WHERE  cash_receipt_id=c_cash_receipt_id
                AND    status = p_application_type
                AND    display='Y';

Line: 79

        SELECT cr.*
        INTO   l_receipt_header
        FROM   ar_cash_receipts cr
        WHERE  cr.payment_server_order_num=p_payment_server_order_num
        AND EXISTS  (SELECT status from ar_cash_receipt_history crh
                    WHERE crh.status = 'REMITTED'
                    AND crh.cash_receipt_id=cr.cash_receipt_id);

Line: 171

     SELECT NVL(prepayment_flag,'N')
     INTO   l_prepayment_flag
     FROM   ra_terms
     WHERE  term_id=p_payment_term_id;

Line: 224

     SELECT NVL(prepayment_flag,'N')
     INTO   l_prepayment_flag
     FROM   ra_customer_trx
     WHERE  customer_trx_id=p_customer_trx_id;