APPS.IEX_STRATEGY_CNT_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1734: hz_cust_acct_sites_all cas,

1730: and st.org_id is null
1731: and st.object_id=hp.party_id
1732: and not exists(select 1 from
1733: hz_cust_accounts ca,
1734: hz_cust_acct_sites_all cas,
1735: hz_cust_site_uses_all su
1736: where hp.party_id = ca.party_id
1737: and ca.cust_account_id=cas.cust_account_id
1738: and cas.cust_acct_site_id=su.cust_acct_site_id

Line 1750: hz_cust_acct_sites_all cas,

1746: where st.object_type='ACCOUNT'
1747: and st.org_id is null
1748: and st.object_id=ca.cust_account_id
1749: and not exists(select 1 from
1750: hz_cust_acct_sites_all cas,
1751: hz_cust_site_uses_all su
1752: where ca.cust_account_id=cas.cust_account_id
1753: and cas.cust_acct_site_id=su.cust_acct_site_id
1754: and su.org_id <> p_org_id);