APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on HZ_CUST_ACCOUNTS_ALL

Line 1578: FROM hz_cust_accounts_all acct,

1574: */
1575: END IF;
1576: UPDATE ams_party_market_segments a
1577: SET a.rollup_party_id = ( SELECT acct.party_id
1578: FROM hz_cust_accounts_all acct,
1579: hz_cust_acct_sites_all acct_site,
1580: hz_cust_site_uses_all site_use
1581: WHERE site_use.site_use_id = NVL(a.bill_to_site_use_id,a.site_use_id)
1582: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id