APPS.FUN_NET_EXTRACT_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 77: hz_cust_site_uses_all hcs,

73: FROM fun_net_ar_txns nat,
74: ra_customer_trx_all rct,
75: hz_parties hp,
76: hz_cust_accounts_all hca,
77: hz_cust_site_uses_all hcs,
78: fun_net_customers_all nc,
79: ra_cust_trx_line_gl_dist_all rctl
80: WHERE nat.batch_id = p_batch_id
81: AND nat.customer_trx_id = rct.customer_trx_id

Line 102: l_location hz_cust_site_uses_all.location%TYPE;

98: l_batch_details c_get_batch_details%ROWTYPE;
99: l_agreement_details c_get_agreement_details%ROWTYPE;
100: l_customer hz_parties.party_name%TYPE;
101: l_customer_number hz_cust_accounts_all.account_number%TYPE;
102: l_location hz_cust_site_uses_all.location%TYPE;
103: l_supplier po_vendors.vendor_name%TYPE;
104: l_supplier_number po_vendors.segment1%TYPE;
105: l_supplier_site po_vendor_sites_all.vendor_site_code%TYPE;
106: l_invoice_count NUMBER;