APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_STRATEGY_TEMPLATES_B

Line 2104: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF

2100: x_strategy_template_id out NOCOPY number) IS
2101: /*
2102: CURSOR c_strategyTemp(pCategoryType varchar2, pDelinquencyID number) IS
2103: SELECT ST.strategy_temp_id, ST.strategy_rank, OBF.ENTITY_NAME
2104: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
2105: where ST.category_type = pCategoryType and ST.Check_List_YN = 'N' AND
2106: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and
2107: OBF.OBJECT_FILTER_TYPE(+) = 'IEXSTRAT'
2108: and not exists

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 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 2354: Select st.Strategy_Temp_ID FROM IEX_STRATEGY_TEMPLATES_B st where

2350: FUNCTION GetDefaultStrategyTempID return NUMBER IS
2351: l_StrategyTempID number;
2352: lCursorStrategyTempID number;
2353: Cursor C_getFirstTempID IS
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

Line 3649: iex_strategy_templates_b tpb

3645: SELECT tpl.strategy_name,
3646: iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',(DECODE(p_strategy_rec.strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT',
3647: 30, 'BILL_TO', 40, 'DELINQUENCY'))) strategy_level_name
3648: FROM iex_strategy_templates_tl tpl,
3649: iex_strategy_templates_b tpb
3650: WHERE tpb.strategy_temp_id = tpl.strategy_temp_id
3651: AND tpl.strategy_temp_id = l_sty_template_id
3652: AND tpl.language = userenv('LANG');
3653: --End added for bug 8708244 gnramasa 31stJuly 09