[Home] [Help]
510: SELECT rm.receipt_method_id receipt_method_id, rm.payment_channel_code payment_channel_code,
511: rc.creation_status receipt_creation_status
512: FROM ar_system_parameters sp,
513: ar_receipt_classes rc,
514: ar_receipt_methods rm
515: WHERE rm.receipt_method_id = decode(p_payment_instrument, /* J Rautiainen ACH Implementation */
516: 'BANK_ACCOUNT', sp.irec_ba_receipt_method_id, /* J Rautiainen ACH Implementation */
517: sp.irec_cc_receipt_method_id) /* J Rautiainen ACH Implementation */
518: AND rm.receipt_class_id = rc.receipt_class_id;
520: --Bug3186314: Cursor to get the payment method at customer/site level.
521: CURSOR cust_payment_method_info_cur(p_siteuseid NUMBER, p_currcode VARCHAR2) IS
522: SELECT arm.receipt_method_id receipt_method_id, arm.payment_channel_code payment_channel_code,
523: arc.creation_status receipt_creation_status
524: FROM ar_receipt_methods arm,
525: ra_cust_receipt_methods rcrm,
526: ar_receipt_method_accounts arma,
527: ce_bank_acct_uses_ou_v aba,
528: ce_bank_accounts cba,
619: --Bug 6339265 : Cursor to get CC Payment Method set in the profile OIR_CC_PMT_METHOD.
620: CURSOR cc_profile_pmt_method_info_cur IS
621: SELECT arm.receipt_method_id receipt_method_id,
622: arc.creation_status receipt_creation_status
623: FROM ar_receipt_methods arm,
624: ar_receipt_method_accounts arma,
625: ce_bank_acct_uses_ou_v aba,
626: ce_bank_accounts cba,
627: ar_receipt_classes arc
639: --Bug 6339265 : Cursor to get Bank Acount Payment Method set in the profile OIR_BA_PMT_METHOD.
640: CURSOR ba_profile_pmt_method_info_cur IS
641: SELECT arm.receipt_method_id receipt_method_id,
642: arc.creation_status receipt_creation_status
643: FROM ar_receipt_methods arm,
644: ar_receipt_method_accounts arma,
645: ce_bank_acct_uses_ou_v aba,
646: ce_bank_accounts cba,
647: ar_receipt_classes arc
4616: cr.currency_code,
4617: rc.creation_status,
4618: cr.org_id,cr.payment_trxn_extension_id
4619: FROM ar_cash_receipts cr,
4620: ar_receipt_methods rm,
4621: ar_receipt_classes rc
4622: WHERE cr.cash_receipt_id = p_cash_receipt_id
4623: AND cr.receipt_method_id = rm.receipt_method_id
4624: and rm.receipt_class_id = rc.receipt_class_id;
5224:
5225: CURSOR cc_profile_pmt_method_info_cur IS
5226: SELECT arm.receipt_method_id receipt_method_id,
5227: arc.creation_status receipt_creation_status
5228: FROM ar_receipt_methods arm,
5229: ar_receipt_method_accounts arma,
5230: ce_bank_acct_uses_ou_v aba,
5231: ce_bank_accounts cba,
5232: ar_receipt_classes arc
5296: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
5297: SELECT /*+ leading(rc) */ count(irec_cc_receipt_method_id)
5298: INTO system_cc_payment_method
5299: FROM ar_system_parameters sp,
5300: ar_receipt_methods rm,
5301: ar_receipt_method_accounts rma,
5302: ce_bank_accounts cba,
5303: ce_bank_acct_uses_ou_v ba,
5304: ar_receipt_classes rc
5323: -- verify that Credit Card payment method is set up at Customer Account Level or Site Level
5324:
5325: SELECT count ( arm.receipt_method_id )
5326: INTO customer_cc_payment_method
5327: FROM ar_receipt_methods arm,
5328: ra_cust_receipt_methods rcrm,
5329: ar_receipt_method_accounts arma,
5330: ce_bank_acct_uses_ou_v aba,
5331: ce_bank_accounts cba,
5411:
5412: CURSOR ba_profile_pmt_method_info_cur IS
5413: SELECT arm.receipt_method_id receipt_method_id,
5414: arc.creation_status receipt_creation_status
5415: FROM ar_receipt_methods arm,
5416: ar_receipt_method_accounts arma,
5417: ce_bank_acct_uses_ou_v aba,
5418: ce_bank_accounts cba,
5419: ar_receipt_classes arc
5481:
5482: SELECT count(irec_ba_receipt_method_id) /* J Rautiainen ACH Implementation */
5483: INTO system_bank_payment_method
5484: FROM ar_system_parameters sp,
5485: ar_receipt_methods rm,
5486: ar_receipt_method_accounts rma,
5487: ce_bank_acct_uses_ou_v ba,
5488: ce_bank_accounts cba
5489: WHERE sp.irec_ba_receipt_method_id = rm.receipt_method_id
5499: -- verify that Bank Account payment method is set up in AR_SYSTEM_PARAMETERS
5500:
5501: SELECT count ( arm.receipt_method_id )
5502: INTO customer_bank_payment_method
5503: FROM ar_receipt_methods arm,
5504: ra_cust_receipt_methods rcrm,
5505: ar_receipt_method_accounts arma,
5506: ce_bank_acct_uses_ou_v aba,
5507: ce_bank_accounts cba,