APPS.AR_IREC_PAYMENTS dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 526: ar_receipt_method_accounts arma,

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,
529: ar_receipt_classes arc
530: WHERE arm.receipt_method_id = rcrm.receipt_method_id

Line 624: ar_receipt_method_accounts arma,

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
628: WHERE arm.payment_channel_code = 'CREDIT_CARD'

Line 644: ar_receipt_method_accounts arma,

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
648: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'

Line 5229: ar_receipt_method_accounts arma,

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
5233: WHERE arm.payment_channel_code = 'CREDIT_CARD'

Line 5301: ar_receipt_method_accounts rma,

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
5305: WHERE sp.irec_cc_receipt_method_id = rm.receipt_method_id

Line 5329: ar_receipt_method_accounts arma,

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,
5332: ar_receipt_classes arc
5333: WHERE arm.receipt_method_id = rcrm.receipt_method_id

Line 5416: ar_receipt_method_accounts arma,

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
5420: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'

Line 5486: ar_receipt_method_accounts rma,

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
5490: AND rma.receipt_method_id = rm.receipt_method_id

Line 5505: ar_receipt_method_accounts arma,

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,
5508: ar_receipt_classes arc
5509: WHERE arm.receipt_method_id = rcrm.receipt_method_id