APPS.IEX_CHECKLIST_UTILITY dependencies on IEX_STRATEGY_TEMPLATE_GROUPS_S

Line 261: ISTL.STRATEGY_TEMP_ID, --IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL, -- bug 9256394

257: ISTL.LAST_UPDATE_DATE,
258: ISTL.LAST_UPDATED_BY,
259: ISTL.LAST_UPDATE_LOGIN,
260: ISTL.REQUEST_ID,
261: ISTL.STRATEGY_TEMP_ID, --IEX_STRATEGY_TEMPLATE_GROUPS_S.NEXTVAL, -- bug 9256394
262: ISTL.STRATEGY_NAME,
263: ISTL.STRATEGY_RANK,
264: ISTL.ENABLED_FLAG,
265: ISTL.CATEGORY_TYPE,

Line 293: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval into l_next_seq from dual;

289:
290: begin
291: select max(strategy_temp_id) into l_max_group from iex_strategy_templates_b;
292:
293: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval into l_next_seq from dual;
294:
295: while l_next_seq <= l_max_group loop
296: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval INTO l_next_seq from dual;
297: end loop;

Line 296: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval INTO l_next_seq from dual;

292:
293: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval into l_next_seq from dual;
294:
295: while l_next_seq <= l_max_group loop
296: select IEX_STRATEGY_TEMPLATE_GROUPS_S.nextval INTO l_next_seq from dual;
297: end loop;
298:
299: exception
300: when others then

Line 343: from iex_object_filters obj, iex_strategy_template_groups stg

339:
340: -- Bug 8479638 by ehuh 5/6/2009
341: Cursor c_object_filter Is
342: select obj.object_id,obj.object_filter_id,obj.last_updated_by,obj.last_update_login
343: from iex_object_filters obj, iex_strategy_template_groups stg
344: where stg.group_id = obj.object_id
345: and obj.object_filter_type = 'IEXSTRAT'
346: and obj.object_id > 10000
347: and (stg.object_filter_id is null or stg.object_filter_id = 0);