DBA Data[Home] [Help]

APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on HZ_CUST_SITE_USES_ALL

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:

Line 1025: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_cust_accounts acct, zx_party_tax_profile ptp

1021: BEGIN
1022: BEGIN
1023: SELECT ptp.party_tax_profile_id
1024: INTO x_party_tax_profile_id
1025: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_cust_accounts acct, zx_party_tax_profile ptp
1026: WHERE siteuse.site_use_id = p_site_use_id and
1027: siteuse.cust_acct_site_id = site.cust_acct_site_id and
1028: site.cust_account_id = acct.cust_account_id and
1029: acct.party_id = ptp.party_id and