APPS.AR_IREC_PAYMENTS dependencies on AR_RECEIPT_CLASSES

Line 520: ar_receipt_classes rc,

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

Line 536: ar_receipt_classes arc

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
538: AND arm.receipt_method_id = arma.receipt_method_id
539: AND arm.receipt_class_id = arc.receipt_class_id
540: AND rcrm.customer_id = p_customer_id

Line 635: ar_receipt_classes arc

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

Line 656: ar_receipt_classes arc

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

Line 1126: l_creation_status ar_receipt_classes.creation_status%TYPE;

1122: l_bank_account_method NUMBER;
1123: l_credit_card_method NUMBER; /* J Rautiainen ACH Implementation */
1124: l_currency_code ar_payment_schedules.invoice_currency_code%type;
1125: l_class ar_payment_schedules.class%TYPE;
1126: l_creation_status ar_receipt_classes.creation_status%TYPE;
1127:
1128: BEGIN
1129:
1130: -- check that function security is allowing access to payment button

Line 5250: ar_receipt_classes rc

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

Line 5504: l_creation_status ar_receipt_classes.creation_status%TYPE;

5500: IS
5501:
5502: l_ccmethodcount NUMBER;
5503: l_bamethodcount NUMBER; /* J Rautiainen ACH Implementation */
5504: l_creation_status ar_receipt_classes.creation_status%TYPE;
5505: l_procedure_name VARCHAR2(30);
5506: BEGIN
5507:
5508: l_procedure_name := '.validate_payment_setup';

Line 5877: ar_receipt_classes arc

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

Line 5949: ar_receipt_classes rc

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
5951: AND rma.receipt_method_id = rm.receipt_method_id
5952: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id
5953: AND ba.bank_account_id = cba.bank_account_id

Line 5978: ar_receipt_classes arc

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
5980: AND arm.receipt_method_id = arma.receipt_method_id
5981: AND arm.receipt_class_id = arc.receipt_class_id
5982: AND rcrm.customer_id = p_customer_id

Line 6066: ar_receipt_classes arc

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

Line 6155: ar_receipt_classes arc

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
6157: AND arm.receipt_method_id = arma.receipt_method_id
6158: AND arm.receipt_class_id = arc.receipt_class_id
6159: AND rcrm.customer_id = p_customer_id