DBA Data[Home] [Help]

APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on HZ_PARTY_SITES

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

1026: BEGIN
1027: BEGIN
1028: SELECT ps.location_id
1029: INTO x_location_id
1030: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_party_sites ps
1031: WHERE siteuse.site_use_id = p_site_use_id and
1032: siteuse.cust_acct_site_id = site.cust_acct_site_id and
1033: site.party_site_id = ps.party_site_id ;
1034: