APPS.OKL_ARINTF_PVT dependencies on HZ_PARTY_SITES

Line 2335: hz_party_sites c

2331: CURSOR Ship_to_csr2( p_customer_num NUMBER, p_install_location NUMBER, p_location NUMBER, p_org_id NUMBER ) IS
2332: SELECT a.CUST_ACCT_SITE_ID
2333: FROM hz_cust_acct_sites_all a,
2334: hz_cust_site_uses_all b,
2335: hz_party_sites c
2336: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID AND
2337: b.site_use_code = 'SHIP_TO' AND
2338: a.party_site_id = c.party_site_id AND
2339: a.cust_account_id = p_customer_num AND