APPS.OKS_EXTWARPRGM_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 326: FROM hz_cust_acct_sites_all ca, hz_cust_site_uses_all cs

322: -- to a bill to site id
323: CURSOR c_cust_csr (p_bill_to_site_use_id NUMBER)
324: IS
325: SELECT ca.cust_account_id
326: FROM hz_cust_acct_sites_all ca, hz_cust_site_uses_all cs
327: WHERE ca.cust_acct_site_id = cs.cust_acct_site_id
328: AND cs.site_use_id = p_bill_to_site_use_id;
329:
330: CURSOR c_party (c_cust_acct_id IN NUMBER)