DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_RECEIPT_METHODS

Line 556: l_payment_method_name ar_receipt_methods.name%TYPE;

552: l_expiration_date IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_EXPIRYDATE%TYPE;
553: l_payment_server_id ra_customer_trx.payment_server_order_num%TYPE;
554: l_approval_code ra_customer_trx.approval_code%TYPE;
555: l_collector ar_collectors.name%TYPE;
556: l_payment_method_name ar_receipt_methods.name%TYPE;
557: l_days_late NUMBER;
558: l_billto_contact varchar2(150);
559: l_salesrep_name ra_salesreps.name%TYPE;
560: BEGIN

Line 595: ar_receipt_methods rm,

591: l_approval_code,
592: l_collector,
593: l_payment_method_name
594: FROM ra_customer_trx trx,
595: ar_receipt_methods rm,
596: hz_parties party,
597: hz_cust_accounts cust,
598: hz_cust_site_uses site_uses,
599: iby_trxn_extensions_v iby

Line 2140: l_payment_method_name ar_receipt_methods.name%TYPE;

2136: l_expiration_date IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_EXPIRYDATE%TYPE;
2137: l_payment_server_id ar_cash_receipts.payment_server_order_num%TYPE;
2138: l_approval_code ra_customer_trx.approval_code%TYPE;
2139: l_collector ar_collectors.name%TYPE;
2140: l_payment_method_name ar_receipt_methods.name%TYPE;
2141: PAY_exception EXCEPTION;
2142:
2143: BEGIN
2144: IF PG_DEBUG in ('Y', 'C') THEN

Line 2241: ar_receipt_methods rm,

2237: l_approval_code,
2238: l_collector,
2239: l_payment_method_name
2240: FROM ar_cash_receipts cr,
2241: ar_receipt_methods rm,
2242: hz_parties party,
2243: hz_cust_accounts cust,
2244: hz_cust_site_uses site_uses,
2245: iby_trxn_extensions_v iby