APPS.ARP_CORRECT_CC_ERRORS dependencies on HZ_CUST_ACCOUNTS

Line 549: l_customer_number hz_cust_accounts.account_number%TYPE;

545: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;
546: l_cc_trx_amount NUMBER;
547: l_cc_trx_date DATE;
548: l_customer_name hz_parties.party_name%TYPE;
549: l_customer_number hz_cust_accounts.account_number%TYPE;
550: l_customer_location hz_cust_site_uses.location%TYPE;
551: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%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;

Line 597: hz_cust_accounts cust,

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
600: WHERE trx.receipt_method_id = rm.receipt_method_id
601: AND rm.payment_channel_code = 'CREDIT_CARD'

Line 2133: l_customer_number hz_cust_accounts.account_number%TYPE;

2129: l_cc_trx_currency ar_cash_receipts.currency_code%TYPE;
2130: l_cc_trx_amount NUMBER;
2131: l_cc_trx_date DATE;
2132: l_customer_name hz_parties.party_name%TYPE;
2133: l_customer_number hz_cust_accounts.account_number%TYPE;
2134: l_customer_location hz_cust_site_uses.location%TYPE;
2135: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%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;

Line 2243: hz_cust_accounts cust,

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