APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on HZ_PARTY_SITES

Line 999: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_party_sites ps

995: BEGIN
996: BEGIN
997: SELECT ps.location_id
998: INTO x_location_id
999: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_party_sites ps
1000: WHERE siteuse.site_use_id = p_site_use_id and
1001: siteuse.cust_acct_site_id = site.cust_acct_site_id and
1002: site.party_site_id = ps.party_site_id ;
1003: