APPS.AR_IREC_PAYMENTS dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 533: ar_receipt_method_accounts arma,

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

Line 632: ar_receipt_method_accounts arma,

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

Line 653: ar_receipt_method_accounts arma,

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

Line 5874: ar_receipt_method_accounts arma,

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

Line 5946: ar_receipt_method_accounts rma,

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

Line 5975: ar_receipt_method_accounts arma,

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

Line 6063: ar_receipt_method_accounts arma,

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

Line 6133: ar_receipt_method_accounts rma,

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

Line 6152: ar_receipt_method_accounts arma,

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