APPS.FUN_NET_ARAP_PKG dependencies on HZ_CUST_SITE_USES

Line 54: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,

50: receipt_number ar_cash_receipts.receipt_number%TYPE,
51: receipt_date ar_cash_receipts.receipt_date%TYPE,
52: gl_date ar_cash_receipts.receipt_date%TYPE,
53: customer_id hz_cust_accounts.cust_account_id%TYPE,
54: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
55: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
56: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
57: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,
58: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,

Line 3049: hz_cust_site_uses_all u

3045: SELECT u.site_use_id
3046: INTO p_cust_site_use_id
3047: FROM fun_net_customers_all fc,
3048: hz_cust_acct_sites_all s,
3049: hz_cust_site_uses_all u
3050: WHERE fc.agreement_id = g_agreement_id
3051: AND fc.cust_account_id = p_cust_acct_id
3052: AND fc.cust_account_id = s.cust_account_id
3053: AND s.cust_acct_site_id = u.cust_acct_site_id

Line 4314: l_cust_site_use_id hz_cust_site_uses.site_use_id%TYPE;

4310: IS
4311: l_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE;
4312: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
4313: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
4314: l_cust_site_use_id hz_cust_site_uses.site_use_id%TYPE;
4315: arReceiptRec arReceiptRecType;
4316: l_bank_acct_used NUMBER;
4317: l_return_status VARCHAR2(1);
4318: l_msg_count NUMBER;