APPS.IEX_STRATEGY_PUB dependencies on IEX_STRATEGY_TEMPLATES_B

Line 945: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF

941: x_strategy_template_id out NOCOPY number) IS
942: /*
943: CURSOR c_strategyTemp(pCategoryType varchar2, pDelinquencyID number) IS
944: SELECT ST.strategy_temp_id, ST.strategy_rank, OBF.ENTITY_NAME
945: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
946: where ST.category_type = pCategoryType and ST.Check_List_YN = 'N' AND
947: OBF.OBJECT_ID(+) = ST.Strategy_temp_ID and
948: OBF.OBJECT_FILTER_TYPE(+) = 'IEXSTRAT'
949: and not exists

Line 996: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF

992: --Start added by gnramasa for bug 6359338 23-Aug-07
993: if p_stry_cnt_rec.object_type in ('LITIGATION', 'REPOSSESSION', 'BANKRUPTCY', 'WRITEOFF') then
994: OPEN c_strategyTemp
995: FOR SELECT ST.strategy_temp_id, to_number(ST.strategy_rank), OBF.ENTITY_NAME, obf.active_flag
996: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
997: where ST.category_type = p_stry_cnt_rec.object_type and ST.Check_List_YN = 'N' AND
998: ((ST.ENABLED_FLAG IS NULL) or ST.ENABLED_FLAG <> 'N') and
999: st.strategy_level = l_DefaultStrategyLevel and
1000: OBF.OBJECT_ID(+) = ST.Strategy_temp_ID and

Line 1012: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF

1008:
1009: IF l_DefaultStrategyLevel = 10 or l_DefaultStrategyLevel = 20 or l_DefaultStrategyLevel = 30 THEN
1010: OPEN c_strategyTemp
1011: FOR SELECT ST.strategy_temp_id, to_number(ST.strategy_rank), OBF.ENTITY_NAME, obf.active_flag
1012: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
1013: where ST.Check_List_YN = 'N' AND
1014: ((ST.ENABLED_FLAG IS NULL) or ST.ENABLED_FLAG <> 'N') and
1015: st.strategy_level = l_DefaultStrategyLevel and
1016: OBF.OBJECT_ID(+) = ST.Strategy_temp_ID and

Line 1025: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF

1021: ORDER BY to_number(strategy_rank) DESC;
1022: ELSE
1023: OPEN c_strategyTemp
1024: FOR SELECT ST.strategy_temp_id, to_number(ST.strategy_rank), OBF.ENTITY_NAME, obf.active_flag
1025: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
1026: where ST.category_type = p_stry_cnt_rec.object_type and ST.Check_List_YN = 'N' AND
1027: ((ST.ENABLED_FLAG IS NULL) or ST.ENABLED_FLAG <> 'N') and
1028: st.strategy_level = l_DefaultStrategyLevel and
1029: OBF.OBJECT_ID(+) = ST.Strategy_temp_ID and

Line 1440: Select Strategy_Temp_ID FROM IEX_STRATEGY_TEMPLATES_B where

1436: FUNCTION GetDefaultStrategyTempID return NUMBER IS
1437: l_StrategyTempID number;
1438: lCursorStrategyTempID number;
1439: Cursor C_getFirstTempID IS
1440: Select Strategy_Temp_ID FROM IEX_STRATEGY_TEMPLATES_B where
1441: Check_List_YN = 'N';
1442: BEGIN
1443: l_StrategyTempID := NVL(to_number(FND_PROFILE.VALUE('IEX_STRATEGY_DEFAULT_TEMPLATE')), 0);
1444: if (l_StrategyTempID = 0) Then