DBA Data[Home] [Help]

APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on HZ_CUST_SITE_USES_ALL

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:

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

1052: BEGIN
1053: BEGIN
1054: SELECT ptp.party_tax_profile_id
1055: INTO x_party_tax_profile_id
1056: FROM hz_cust_site_uses_all siteuse, hz_cust_acct_sites_all site, hz_cust_accounts acct, zx_party_tax_profile ptp
1057: WHERE siteuse.site_use_id = p_site_use_id and
1058: siteuse.cust_acct_site_id = site.cust_acct_site_id and
1059: site.cust_account_id = acct.cust_account_id and
1060: acct.party_id = ptp.party_id and