APPS.FUN_NET_ARAP_PKG dependencies on HZ_CUST_SITE_USES

Line 66: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,

62: receipt_number ar_cash_receipts.receipt_number%TYPE,
63: receipt_date ar_cash_receipts.receipt_date%TYPE,
64: gl_date ar_cash_receipts.receipt_date%TYPE,
65: customer_id hz_cust_accounts.cust_account_id%TYPE,
66: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
67: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
68: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
69: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,
70: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,

Line 2379: hz_cust_site_uses u

2375: INTO p_cust_site_use_id
2376: FROM
2377: fun_net_customers fc,
2378: hz_cust_acct_sites s,
2379: hz_cust_site_uses u
2380: WHERE
2381: fc.agreement_id = g_agreement_id
2382: AND
2383: fc.cust_account_id = p_cust_acct_id

Line 3708: l_cust_site_use_id hz_cust_site_uses.site_use_id%TYPE;

3704:
3705: l_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE;
3706: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
3707: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
3708: l_cust_site_use_id hz_cust_site_uses.site_use_id%TYPE;
3709: arReceiptRec arReceiptRecType;
3710:
3711: l_bank_acct_used NUMBER;
3712: l_return_status VARCHAR2(1);