APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on DUAL

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

132: l_def_pref_id number;
133: l_plan_type number;
134: BEGIN
135: -- Get category set from profile option for IO
136: -- SELECT fnd_profile.value('MSR_BUDGET_CATEGORY_SET') INTO l_cat_set_id FROM dual;
137: l_plan_type := get_plan_type(p_plan_id);
138: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
139: l_cat_set_id:= msc_get_name.GET_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);
140: return l_cat_set_id;

Line 2033: FROM dual;

2029: l_default_category_set_id := get_cat_set_id(p_plan_id);
2030:
2031: SELECT msc_form_query_s.nextval
2032: INTO p_query_id
2033: FROM dual;
2034:
2035: IF org_id IS NOT NULL THEN
2036: l_sr_instance_id := get_inst_id_from_org_key(org_id);
2037: l_sr_tp_id := get_sr_tp_id_from_org_key(org_id);

Line 2278: FROM dual;

2274: BEGIN
2275:
2276: SELECT msc_form_query_s.nextval
2277: INTO query_id
2278: FROM dual;
2279:
2280: IF org_id IS NOT NULL THEN
2281: sr_instance_id := get_inst_id_from_org_key(org_id);
2282: sr_tp_id := get_sr_tp_id_from_org_key(org_id);

Line 2331: FROM dual;

2327: l_default_category_set_id := get_cat_set_id(plan_id);
2328:
2329: SELECT msc_form_query_s.nextval
2330: INTO p_query_id
2331: FROM dual;
2332:
2333: IF org_id IS NOT NULL THEN
2334: l_sr_instance_id := get_inst_id_from_org_key(org_id);
2335: l_sr_tp_id := get_sr_tp_id_from_org_key(org_id);