APPS.AR_IREC_PAYMENTS dependencies on AR_RECEIPT_CLASSES

Line 513: ar_receipt_classes rc,

509: CURSOR payment_method_info_cur IS
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 */

Line 529: ar_receipt_classes arc

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
531: AND arm.receipt_method_id = arma.receipt_method_id
532: AND arm.receipt_class_id = arc.receipt_class_id
533: AND rcrm.customer_id = p_customer_id

Line 627: ar_receipt_classes arc

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'
629: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)
630: AND arm.receipt_method_id = arma.receipt_method_id
631: AND arm.receipt_class_id = arc.receipt_class_id

Line 647: ar_receipt_classes arc

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'
649: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)
650: AND arm.receipt_method_id = arma.receipt_method_id
651: AND arm.receipt_class_id = arc.receipt_class_id

Line 1058: l_creation_status ar_receipt_classes.creation_status%TYPE;

1054: l_bank_account_method NUMBER;
1055: l_credit_card_method NUMBER; /* J Rautiainen ACH Implementation */
1056: l_currency_code ar_payment_schedules.invoice_currency_code%type;
1057: l_class ar_payment_schedules.class%TYPE;
1058: l_creation_status ar_receipt_classes.creation_status%TYPE;
1059:
1060: BEGIN
1061:
1062: -- check that function security is allowing access to payment button

Line 4621: ar_receipt_classes rc

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;
4625:

Line 4870: l_creation_status ar_receipt_classes.creation_status%TYPE;

4866: IS
4867:
4868: l_ccmethodcount NUMBER;
4869: l_bamethodcount NUMBER; /* J Rautiainen ACH Implementation */
4870: l_creation_status ar_receipt_classes.creation_status%TYPE;
4871: l_procedure_name VARCHAR2(30);
4872: BEGIN
4873:
4874: l_procedure_name := '.validate_payment_setup';

Line 5232: ar_receipt_classes arc

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'
5234: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)
5235: AND arm.receipt_method_id = arma.receipt_method_id
5236: AND arm.receipt_class_id = arc.receipt_class_id

Line 5304: ar_receipt_classes rc

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
5306: AND rma.receipt_method_id = rm.receipt_method_id
5307: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id
5308: AND ba.bank_account_id = cba.bank_account_id

Line 5332: ar_receipt_classes arc

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
5334: AND arm.receipt_method_id = arma.receipt_method_id
5335: AND arm.receipt_class_id = arc.receipt_class_id
5336: AND rcrm.customer_id = p_customer_id

Line 5419: ar_receipt_classes arc

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'
5421: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)
5422: AND arm.receipt_method_id = arma.receipt_method_id
5423: AND arm.receipt_class_id = arc.receipt_class_id

Line 5508: ar_receipt_classes arc

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
5510: AND arm.receipt_method_id = arma.receipt_method_id
5511: AND arm.receipt_class_id = arc.receipt_class_id
5512: AND rcrm.customer_id = p_customer_id