APPS.OKS_EXTWARPRGM_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 286: FROM hz_cust_acct_sites_all ca, hz_cust_site_uses_all cs

282: -- to a bill to site id
283: CURSOR c_cust_csr (p_bill_to_site_use_id NUMBER)
284: IS
285: SELECT ca.cust_account_id
286: FROM hz_cust_acct_sites_all ca, hz_cust_site_uses_all cs
287: WHERE ca.cust_acct_site_id = cs.cust_acct_site_id
288: AND cs.site_use_id = p_bill_to_site_use_id;
289:
290: CURSOR c_party (c_cust_acct_id IN NUMBER)