DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_RECEIPT_METHODS

Line 565: l_payment_method_name ar_receipt_methods.name%TYPE;

561: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
562: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%TYPE;
563: l_approval_code ra_customer_trx.approval_code%TYPE;
564: l_collector ar_collectors.name%TYPE;
565: l_payment_method_name ar_receipt_methods.name%TYPE;
566: l_days_late NUMBER;
567: l_billto_contact varchar2(150);
568: l_salesrep_name ra_salesreps.name%TYPE;
569: BEGIN

Line 602: ar_receipt_methods rm,

598: l_approval_code,
599: l_collector,
600: l_payment_method_name
601: FROM ra_customer_trx trx,
602: ar_receipt_methods rm,
603: hz_parties party,
604: hz_cust_accounts cust,
605: hz_cust_site_uses site_uses,
606: iby_trxn_extensions_v iby,

Line 2277: l_payment_method_name ar_receipt_methods.name%TYPE;

2273: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
2274: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
2275: l_approval_code ra_customer_trx.approval_code%TYPE;
2276: l_collector ar_collectors.name%TYPE;
2277: l_payment_method_name ar_receipt_methods.name%TYPE;
2278: PAY_exception EXCEPTION;
2279:
2280: BEGIN
2281: IF PG_DEBUG in ('Y', 'C') THEN

Line 2377: ar_receipt_methods rm,

2373: l_approval_code,
2374: l_collector,
2375: l_payment_method_name
2376: FROM ar_cash_receipts cr,
2377: ar_receipt_methods rm,
2378: hz_parties party,
2379: hz_cust_accounts cust,
2380: hz_cust_site_uses site_uses,
2381: iby_trxn_extensions_v iby