APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on HZ_CUST_ACCOUNTS_ALL

Line 1591: FROM hz_cust_accounts_all acct,

1587: */
1588: END IF;
1589: UPDATE ams_party_market_segments a
1590: SET a.rollup_party_id = ( SELECT acct.party_id
1591: FROM hz_cust_accounts_all acct,
1592: hz_cust_acct_sites_all acct_site,
1593: hz_cust_site_uses_all site_use
1594: WHERE site_use.site_use_id = NVL(a.bill_to_site_use_id,a.site_use_id)
1595: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id