APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_STRATEGY_TEMPLATE_GROUPS

Line 2187: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF , iex_strategy_template_groups temgp

2183:
2184: IF l_DefaultStrategyLevel = 10 or l_DefaultStrategyLevel = 20 or l_DefaultStrategyLevel = 30 THEN
2185: OPEN c_strategyTemp
2186: FOR SELECT ST.strategy_temp_id, to_number(ST.strategy_rank), OBF.ENTITY_NAME, obf.active_flag
2187: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF , iex_strategy_template_groups temgp
2188: where ST.Check_List_YN = l_No AND
2189: ((ST.ENABLED_FLAG IS NULL) or ST.ENABLED_FLAG <> l_No) and
2190: st.strategy_level = l_DefaultStrategyLevel and
2191: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and

Line 2204: and exists (select 1 from iex_strategy_template_groups tg

2200: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
2201: and ST.STRATEGY_RANK <= p_stry_cnt_rec.SCORE_VALUE
2202: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
2203: -- Bug 7392752 by Ehuh
2204: and exists (select 1 from iex_strategy_template_groups tg
2205: where tg.group_id = st.strategy_temp_group_id
2206: and tg.enabled_flag <> 'N'
2207: and trunc(sysdate) between trunc(nvl(tg.valid_from_dt,sysdate))
2208: and trunc(nvl(tg.valid_to_dt,sysdate)) )

Line 2214: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF , iex_strategy_template_groups temgp

2210: ORDER BY to_number(st.strategy_rank) DESC;
2211: ELSE
2212: OPEN c_strategyTemp
2213: FOR SELECT ST.strategy_temp_id, to_number(ST.strategy_rank), OBF.ENTITY_NAME, obf.active_flag
2214: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF , iex_strategy_template_groups temgp
2215: where ST.category_type = chk_obj_type and ST.Check_List_YN = l_No AND
2216: ((ST.ENABLED_FLAG IS NULL) or ST.ENABLED_FLAG <> l_No) and
2217: st.strategy_level = l_DefaultStrategyLevel and
2218: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and

Line 2231: and exists (select 1 from iex_strategy_template_groups tg

2227: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
2228: and ST.STRATEGY_RANK <= p_stry_cnt_rec.SCORE_VALUE
2229: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
2230: -- Bug 7392752 by Ehuh
2231: and exists (select 1 from iex_strategy_template_groups tg
2232: where tg.group_id = st.strategy_temp_group_id
2233: and tg.enabled_flag <> 'N'
2234: and trunc(sysdate) between trunc(nvl(tg.valid_from_dt,sysdate))
2235: and trunc(nvl(tg.valid_to_dt,sysdate)) )

Line 2358: and exists (select 1 from iex_strategy_template_groups tg

2354: Select st.Strategy_Temp_ID FROM IEX_STRATEGY_TEMPLATES_B st where
2355: st.Check_List_YN = l_No AND st.ENABLED_FLAG <> l_No
2356: -- Bug 7392752 by Ehuh
2357: and (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(st.valid_from_dt, SYSDATE)) AND TRUNC(NVL(st.valid_to_dt, SYSDATE)))
2358: and exists (select 1 from iex_strategy_template_groups tg
2359: where tg.group_id = st.strategy_temp_group_id
2360: and tg.enabled_flag <> 'N'
2361: and trunc(sysdate) between trunc(nvl(tg.valid_from_dt,sysdate))
2362: and trunc(nvl(tg.valid_to_dt,sysdate)) );