[Home] [Help]
517: SELECT rm.receipt_method_id receipt_method_id, rm.payment_channel_code payment_channel_code,
518: rc.creation_status receipt_creation_status
519: FROM ar_system_parameters sp,
520: ar_receipt_classes rc,
521: ar_receipt_methods rm
522: WHERE rm.receipt_method_id = decode(p_payment_instrument, /* J Rautiainen ACH Implementation */
523: 'BANK_ACCOUNT', sp.irec_ba_receipt_method_id, /* J Rautiainen ACH Implementation */
524: sp.irec_cc_receipt_method_id) /* J Rautiainen ACH Implementation */
525: AND rm.receipt_class_id = rc.receipt_class_id;
527: --Bug3186314: Cursor to get the payment method at customer/site level.
528: CURSOR cust_payment_method_info_cur(p_siteuseid NUMBER, p_currcode VARCHAR2) IS
529: SELECT arm.receipt_method_id receipt_method_id, arm.payment_channel_code payment_channel_code,
530: arc.creation_status receipt_creation_status
531: FROM ar_receipt_methods arm,
532: ra_cust_receipt_methods rcrm,
533: ar_receipt_method_accounts arma,
534: ce_bank_acct_uses_ou_v aba,
535: ce_bank_accounts cba,
627: CURSOR cc_profile_pmt_method_info_cur IS
628: SELECT arm.receipt_method_id receipt_method_id,
629: arm.payment_channel_code payment_channel_code,
630: arc.creation_status receipt_creation_status
631: FROM ar_receipt_methods arm,
632: ar_receipt_method_accounts arma,
633: ce_bank_acct_uses_ou_v aba,
634: ce_bank_accounts cba,
635: ar_receipt_classes arc
648: CURSOR ba_profile_pmt_method_info_cur IS
649: SELECT arm.receipt_method_id receipt_method_id,
650: arm.payment_channel_code payment_channel_code,
651: arc.creation_status receipt_creation_status
652: FROM ar_receipt_methods arm,
653: ar_receipt_method_accounts arma,
654: ce_bank_acct_uses_ou_v aba,
655: ce_bank_accounts cba,
656: ar_receipt_classes arc
5245: rc.creation_status,
5246: cr.org_id,cr.payment_trxn_extension_id,
5247: cr.receipt_method_id
5248: FROM ar_cash_receipts cr,
5249: ar_receipt_methods rm,
5250: ar_receipt_classes rc
5251: WHERE cr.cash_receipt_id = p_cash_receipt_id
5252: AND cr.receipt_method_id = rm.receipt_method_id
5253: and rm.receipt_class_id = rc.receipt_class_id;
5869:
5870: CURSOR cc_profile_pmt_method_info_cur IS
5871: SELECT arm.receipt_method_id receipt_method_id,
5872: arc.creation_status receipt_creation_status
5873: FROM ar_receipt_methods arm,
5874: ar_receipt_method_accounts arma,
5875: ce_bank_acct_uses_ou_v aba,
5876: ce_bank_accounts cba,
5877: ar_receipt_classes arc
5941: -- Bug 3886652 - Customer Id and Customer Site Use Id added as params to ARI_CONFIG.save_payment_instrument_info
5942: SELECT /*+ leading(rc) */ count(irec_cc_receipt_method_id)
5943: INTO system_cc_payment_method
5944: FROM ar_system_parameters sp,
5945: ar_receipt_methods rm,
5946: ar_receipt_method_accounts rma,
5947: ce_bank_accounts cba,
5948: ce_bank_acct_uses_ou_v ba,
5949: ar_receipt_classes rc
5969: -- verify that Credit Card payment method is set up at Customer Account Level or Site Level
5970:
5971: SELECT count ( arm.receipt_method_id )
5972: INTO customer_cc_payment_method
5973: FROM ar_receipt_methods arm,
5974: ra_cust_receipt_methods rcrm,
5975: ar_receipt_method_accounts arma,
5976: ce_bank_acct_uses_ou_v aba,
5977: ce_bank_accounts cba,
6058:
6059: CURSOR ba_profile_pmt_method_info_cur IS
6060: SELECT arm.receipt_method_id receipt_method_id,
6061: arc.creation_status receipt_creation_status
6062: FROM ar_receipt_methods arm,
6063: ar_receipt_method_accounts arma,
6064: ce_bank_acct_uses_ou_v aba,
6065: ce_bank_accounts cba,
6066: ar_receipt_classes arc
6128:
6129: SELECT count(irec_ba_receipt_method_id) /* J Rautiainen ACH Implementation */
6130: INTO system_bank_payment_method
6131: FROM ar_system_parameters sp,
6132: ar_receipt_methods rm,
6133: ar_receipt_method_accounts rma,
6134: ce_bank_acct_uses_ou_v ba,
6135: ce_bank_accounts cba
6136: WHERE sp.irec_ba_receipt_method_id = rm.receipt_method_id
6146: -- verify that Bank Account payment method is set up in AR_SYSTEM_PARAMETERS
6147:
6148: SELECT count ( arm.receipt_method_id )
6149: INTO customer_bank_payment_method
6150: FROM ar_receipt_methods arm,
6151: ra_cust_receipt_methods rcrm,
6152: ar_receipt_method_accounts arma,
6153: ce_bank_acct_uses_ou_v aba,
6154: ce_bank_accounts cba,