DBA Data[Home] [Help]

APPS.IEX_STRATEGY_PUB dependencies on IEX_STRATEGY_TEMPLATE_GROUPS

Line 1064: and exists (select 1 from iex_strategy_template_groups tg

1060: OBF.OBJECT_ID(+) = ST.Strategy_temp_group_ID and
1061: OBF.OBJECT_FILTER_TYPE(+) = 'IEXSTRAT'
1062: and (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(st.valid_from_dt, SYSDATE))
1063: AND TRUNC(NVL(st.valid_to_dt, SYSDATE)))
1064: and exists (select 1 from iex_strategy_template_groups tg
1065: where tg.group_id = st.strategy_temp_group_id
1066: and tg.enabled_flag <> 'N'
1067: and trunc(sysdate) between trunc(nvl(tg.valid_from_dt,sysdate))
1068: and trunc(nvl(tg.valid_to_dt,sysdate)) )