APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_STRATEGY_TEMPLATE_GROUPS

Line 1427: and exists (select 1 from iex_strategy_template_groups tg

1423: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
1424: and ST.STRATEGY_RANK <= p_stry_cnt_rec.SCORE_VALUE
1425: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
1426: -- Bug 7392752 by Ehuh
1427: and exists (select 1 from iex_strategy_template_groups tg
1428: where tg.group_id = st.strategy_temp_group_id
1429: and tg.enabled_flag <> 'N'
1430: and trunc(sysdate) between trunc(nvl(tg.valid_from_dt,sysdate))
1431: and trunc(nvl(tg.valid_to_dt,sysdate)) )

Line 1451: and exists (select 1 from iex_strategy_template_groups tg

1447: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
1448: and ST.STRATEGY_RANK <= p_stry_cnt_rec.SCORE_VALUE
1449: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
1450: -- Bug 7392752 by Ehuh
1451: and exists (select 1 from iex_strategy_template_groups tg
1452: where tg.group_id = st.strategy_temp_group_id
1453: and tg.enabled_flag <> 'N'
1454: and trunc(sysdate) between trunc(nvl(tg.valid_from_dt,sysdate))
1455: and trunc(nvl(tg.valid_to_dt,sysdate)) )

Line 1574: and exists (select 1 from iex_strategy_template_groups tg

1570: Select st.Strategy_Temp_ID FROM IEX_STRATEGY_TEMPLATES_B st where
1571: st.Check_List_YN = l_No AND st.ENABLED_FLAG <> l_No
1572: -- Bug 7392752 by Ehuh
1573: and (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(st.valid_from_dt, SYSDATE)) AND TRUNC(NVL(st.valid_to_dt, SYSDATE)))
1574: and exists (select 1 from iex_strategy_template_groups tg
1575: where tg.group_id = st.strategy_temp_group_id
1576: and tg.enabled_flag <> 'N'
1577: and trunc(sysdate) between trunc(nvl(tg.valid_from_dt,sysdate))
1578: and trunc(nvl(tg.valid_to_dt,sysdate)) );