APPS.ARP_CORRECT_CC_ERRORS dependencies on HZ_CUST_ACCOUNTS

Line 559: l_customer_number hz_cust_accounts.account_number%TYPE;

555: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;
556: l_cc_trx_amount NUMBER;
557: l_cc_trx_date DATE;
558: l_customer_name hz_parties.party_name%TYPE;
559: l_customer_number hz_cust_accounts.account_number%TYPE;
560: l_customer_location hz_cust_site_uses.location%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;

Line 604: hz_cust_accounts cust,

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,
607: iby_fndcpt_pmt_chnnls_b pc
608: WHERE trx.receipt_method_id = rm.receipt_method_id

Line 2271: l_customer_number hz_cust_accounts.account_number%TYPE;

2267: l_cc_trx_currency ar_cash_receipts.currency_code%TYPE;
2268: l_cc_trx_amount NUMBER;
2269: l_cc_trx_date DATE;
2270: l_customer_name hz_parties.party_name%TYPE;
2271: l_customer_number hz_cust_accounts.account_number%TYPE;
2272: l_customer_location hz_cust_site_uses.location%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;

Line 2379: hz_cust_accounts cust,

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
2382: WHERE rm.receipt_method_id = cr.receipt_method_id
2383: AND cr.pay_from_customer = cust.cust_account_id (+)