APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on DUAL

Line 150: -- SELECT fnd_profile.value('MSR_BUDGET_CATEGORY_SET') INTO l_cat_set_id FROM dual;

146: l_def_pref_id number;
147: l_plan_type number;
148: BEGIN
149: -- Get category set from profile option for IO
150: -- SELECT fnd_profile.value('MSR_BUDGET_CATEGORY_SET') INTO l_cat_set_id FROM dual;
151: l_plan_type := get_plan_type(p_plan_id);
152: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
153: l_cat_set_id:= msc_get_name.GET_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);
154: return l_cat_set_id;

Line 2448: FROM dual;

2444: l_default_category_set_id := get_cat_set_id(p_plan_id);
2445:
2446: SELECT msc_form_query_s.nextval
2447: INTO p_query_id
2448: FROM dual;
2449:
2450: IF org_id IS NOT NULL THEN
2451: l_sr_instance_id := get_inst_id_from_org_key(org_id);
2452: l_sr_tp_id := get_sr_tp_id_from_org_key(org_id);

Line 2693: FROM dual;

2689: BEGIN
2690:
2691: SELECT msc_form_query_s.nextval
2692: INTO query_id
2693: FROM dual;
2694:
2695: IF org_id IS NOT NULL THEN
2696: sr_instance_id := get_inst_id_from_org_key(org_id);
2697: sr_tp_id := get_sr_tp_id_from_org_key(org_id);

Line 2746: FROM dual;

2742: l_default_category_set_id := get_cat_set_id(plan_id);
2743:
2744: SELECT msc_form_query_s.nextval
2745: INTO p_query_id
2746: FROM dual;
2747:
2748: IF org_id IS NOT NULL THEN
2749: l_sr_instance_id := get_inst_id_from_org_key(org_id);
2750: l_sr_tp_id := get_sr_tp_id_from_org_key(org_id);