DBA Data[Home] [Help]

APPS.MSC_X_HZ_PLAN dependencies on MSC_FORM_QUERY_S

Line 2730: select msc_form_query_s.nextval into l_query_id from dual;

2726:
2727: -- insert all the items of the category into temp table msc_form_query.
2728: -- store all the item ids in number1 column of msc_form_query temp table.
2729: if (v_category is not null) then
2730: select msc_form_query_s.nextval into l_query_id from dual;
2731: OPEN category_items(v_category);
2732: LOOP
2733: FETCH category_items into l_item_id;
2734: EXIT WHEN category_items%NOTFOUND;