APPS.ARP_CORRECT_CC_ERRORS dependencies on HZ_CUST_SITE_USES

Line 560: l_customer_location hz_cust_site_uses.location%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;
564: l_collector ar_collectors.name%TYPE;

Line 605: hz_cust_site_uses site_uses,

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
609: AND rm.payment_channel_code = pc.payment_channel_code

Line 2272: l_customer_location hz_cust_site_uses.location%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;
2276: l_collector ar_collectors.name%TYPE;

Line 2380: hz_cust_site_uses site_uses,

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 (+)
2384: AND cust.party_id = party.party_id (+)