APPS.IEX_STRATEGY_PUB dependencies on IEX_OBJECT_FILTERS

Line 986: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF

982: x_strategy_template_id out NOCOPY number) IS
983: /*
984: CURSOR c_strategyTemp(pCategoryType varchar2, pDelinquencyID number) IS
985: SELECT ST.strategy_temp_id, ST.strategy_rank, OBF.ENTITY_NAME
986: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
987: where ST.category_type = pCategoryType and ST.Check_List_YN = 'N' AND
988: OBF.OBJECT_ID(+) = ST.Strategy_temp_ID and
989: OBF.OBJECT_FILTER_TYPE(+) = 'IEXSTRAT'
990: and not exists

Line 1056: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF

1052: --Start added by gnramasa for bug 6359338 23-Aug-07
1053: if p_stry_cnt_rec.object_type in ('LITIGATION', 'REPOSSESSION', 'BANKRUPTCY', 'WRITEOFF') then
1054: OPEN c_strategyTemp
1055: FOR SELECT ST.strategy_temp_id, to_number(ST.strategy_rank), OBF.ENTITY_NAME, obf.active_flag
1056: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
1057: where ST.category_type = p_stry_cnt_rec.object_type and ST.Check_List_YN = 'N' AND
1058: ((ST.ENABLED_FLAG IS NULL) or ST.ENABLED_FLAG <> 'N') and
1059: st.strategy_level = l_DefaultStrategyLevel and
1060: OBF.OBJECT_ID(+) = ST.Strategy_temp_group_ID and

Line 1077: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF

1073:
1074: IF l_DefaultStrategyLevel = 10 or l_DefaultStrategyLevel = 20 or l_DefaultStrategyLevel = 30 THEN
1075: OPEN c_strategyTemp
1076: FOR SELECT ST.strategy_temp_id, to_number(ST.strategy_rank), OBF.ENTITY_NAME, obf.active_flag
1077: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
1078: where ST.Check_List_YN = 'N' AND
1079: ((ST.ENABLED_FLAG IS NULL) or ST.ENABLED_FLAG <> 'N') and
1080: st.strategy_level = l_DefaultStrategyLevel and
1081: OBF.OBJECT_ID(+) = ST.Strategy_temp_ID and

Line 1090: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF

1086: ORDER BY to_number(strategy_rank) DESC;
1087: ELSE
1088: OPEN c_strategyTemp
1089: FOR SELECT ST.strategy_temp_id, to_number(ST.strategy_rank), OBF.ENTITY_NAME, obf.active_flag
1090: from IEX_STRATEGY_TEMPLATES_B ST, IEX_OBJECT_FILTERS OBF
1091: where ST.category_type = p_stry_cnt_rec.object_type and ST.Check_List_YN = 'N' AND
1092: ((ST.ENABLED_FLAG IS NULL) or ST.ENABLED_FLAG <> 'N') and
1093: st.strategy_level = l_DefaultStrategyLevel and
1094: OBF.OBJECT_ID(+) = ST.Strategy_temp_ID and