APPS.IEX_STRATEGY_CNT_PUB dependencies on HZ_CUST_ACCOUNTS

Line 1733: hz_cust_accounts ca,

1729: where st.object_type='PARTY'
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

Line 1745: hz_cust_accounts ca

1741:
1742: cursor c_account_strat_wo_ou(p_org_id number)
1743: is select st.strategy_id,p_org_id
1744: from iex_strategies st,
1745: hz_cust_accounts ca
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