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,
	    pr.home_country
     FROM   ar_cash_receipts_all cr,
            ar_receipt_methods rm,
            ar_receipt_classes rc,
            hz_cust_accounts hca,
            hz_parties    party,
	    /* Need to pass country code for SEPA specific receipts */
	    ce_bank_acct_uses bau,
            ce_bank_accounts cba,
            hz_parties bank,
	    hz_organization_profiles pr
     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
     AND    bau.bank_acct_use_id = cr.remit_bank_acct_use_id
     AND    cba.bank_account_id = bau.bank_account_id
     AND    bank.party_id = cba.bank_id
     AND    pr.party_id = bank.party_id;

Line: 293

             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: 407

                SELECT ar_receivable_applications_s1.nextval
                INTO   l_payment_set_id
                FROM   dual;

Line: 444

                   SELECT payment_channel_code
                   INTO   l_payment_type
                   FROM  ar_receipt_methods
                   WHERE  receipt_method_id = p_receipt_method_id;

Line: 542

                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: 567

                  select AUTHORIZATION_ID
                   into l_auth_id
                   from IBY_TRXN_EXT_AUTHS_V
                   where TRXN_EXTENSION_ID = p_payment_trxn_extension_id
		   and AUTHORIZATION_STATUS = 0;

Line: 579

                  ARP_CASH_RECEIPTS_PKG.update_p(l_cr_rec, l_cash_receipt_id);

Line: 581

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

Line: 657

               ARP_CASH_RECEIPTS_PKG.update_p(l_cr_rec, l_cash_receipt_id);

Line: 660

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

Line: 811

                   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;