APPS.OKL_ARINTF_PVT dependencies on HZ_PARTY_SITES

Line 1369: hz_party_sites c

1365: CURSOR Ship_to_csr2( p_customer_num NUMBER, p_install_location NUMBER, p_location NUMBER, p_org_id NUMBER ) IS
1366: SELECT a.CUST_ACCT_SITE_ID
1367: FROM hz_cust_acct_sites_all a,
1368: hz_cust_site_uses_all b,
1369: hz_party_sites c
1370: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID AND
1371: b.site_use_code = 'SHIP_TO' AND
1372: a.party_site_id = c.party_site_id AND
1373: a.cust_account_id = p_customer_num AND