APPS.IEX_CHECKLIST_UTILITY dependencies on DUAL

Line 194: FROM dual;

190: WHERE score_comp_type_id = p_score_comp_type_id;
191: ELSE
192: SELECT iex_metric_ratings_s.nextval
193: INTO l_metric_rating_id
194: FROM dual;
195:
196: INSERT INTO iex_metric_ratings(metric_rating_id, score_comp_type_id, low_from, low_to,
197: medium_from, medium_to, high_from, high_to,
198: creation_date, created_by, last_update_date, last_updated_by, last_update_login)

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 335: FROM dual;

331: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
332: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
333: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
334: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin
335: FROM dual;
336:
337: l_general_info_row c_general_info%ROWTYPE;
338: l_status VARCHAR2(30);
339: