APPS.AR_PREPAYMENTS_PUB SQL Statements

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

Line: 170

     SELECT cr.receipt_number,
            cr.amount,
            cr.currency_code,
            rm.PAYMENT_CHANNEL_CODE,       /* NEW ADDED */
            rc.creation_status,            /* AR USE */
            cr.org_id,
            cr.payment_trxn_extension_id,
            party.party_id,
            cr.pay_from_customer,
            cr.customer_site_use_id
     FROM   ar_cash_receipts_all cr,
            ar_receipt_methods rm,
            ar_receipt_classes rc,
            hz_cust_accounts hca,
            hz_parties    party
     WHERE  cr.cash_receipt_id = l_cash_receipt_id
     AND    hca.party_id = party.party_id
     AND    hca.cust_account_id = cr.pay_from_customer
     AND  cr.receipt_method_id = rm.receipt_method_id
     and  rm.receipt_class_id = rc.receipt_class_id;

Line: 283

             SELECT 'Y' into l_cc_check
             FROM  ar_receipt_methods
             WHERE receipt_method_id=p_receipt_method_id
             AND   payment_type_code = 'CREDIT_CARD';

Line: 397

                SELECT ar_receivable_applications_s1.nextval
                INTO   l_payment_set_id
                FROM   dual;

Line: 434

                   SELECT payment_channel_code
                   INTO   l_payment_type
                   FROM  ar_receipt_methods
                   WHERE  receipt_method_id = p_receipt_method_id;

Line: 531

                SELECT decode(summ.status,   NULL,   'N',   'Y') AUTHORIZED_FLAG
                   into l_auth_flag
                 FROM iby_trxn_summaries_all summ,
                      iby_fndcpt_tx_operations op
                WHERE summ.transactionid = op.transactionid
                      AND reqtype = 'ORAPMTREQ'
                      AND status IN(0,    100)
                      AND trxntypeid IN(2,   3, 20)
                      AND op.trxn_extension_id = l_trxn_entity_id
                      AND summ.trxnmid =
                           (SELECT MAX(trxnmid)
                                FROM iby_trxn_summaries_all
                            WHERE transactionid = summ.transactionid
                            AND reqtype = 'ORAPMTREQ'
                            AND status IN(0, 100)
                            AND trxntypeid IN(2,    3,   20));

Line: 556

                  select AUTHORIZATION_ID
                   into l_auth_id
                   from IBY_TRXN_EXT_AUTHS_V
                   where TRXN_EXTENSION_ID = p_payment_trxn_extension_id;

Line: 567

                  ARP_CASH_RECEIPTS_PKG.update_p(l_cr_rec, l_cash_receipt_id);

Line: 569

               arp_standard.debug('CR rec updated with auth_id and auth code ');

Line: 644

               ARP_CASH_RECEIPTS_PKG.update_p(l_cr_rec, l_cash_receipt_id);

Line: 647

                 arp_standard.debug('CR rec updated with auth_id and auth code ');

Line: 796

                   SELECT rc.creation_status ,  nvl(rm.payment_channel_code, 'CHECK')
                   INTO   l_cash_receipt_status,  l_payment_type
                   FROM  ar_cash_receipts cr, ar_receipt_classes rc,
                         ar_receipt_methods rm
                   WHERE cr.cash_receipt_id = l_cash_receipt_id
                   AND   cr.receipt_method_id = rm.receipt_method_id
                   AND   rm.receipt_class_id = rc.receipt_class_id;