DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_FORM_QUERY_S

Line 2446: SELECT msc_form_query_s.nextval

2442:
2443: -- Get default category set
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

Line 2691: SELECT msc_form_query_s.nextval

2687: l_planlist PlanList;
2688: l_index BINARY_INTEGER;
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

Line 2744: SELECT msc_form_query_s.nextval

2740:
2741: -- Get default category set
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