DBA Data[Home] [Help]

APPS.MSC_NETCHANGE_PKG dependencies on MSC_FORM_QUERY_S

Line 170: select msc_form_query_s.nextval

166: from mfg_lookups
167: where lookup_type = 'MSC_NC_MISC_PROMPTS'
168: order by lookup_code;
169:
170: select msc_form_query_s.nextval
171: into g_options_query_id
172: from dual;
173:
174: option_query_id :=g_options_query_id;

Line 1186: select msc_form_query_s.nextval

1182:
1183: checkPlanStatus(g_from_plan, g_to_plan,p_plan_status,p_report_id);
1184:
1185: if g_need_insert_temp then
1186: select msc_form_query_s.nextval
1187: into g_excp_query_id
1188: from dual;
1189: else
1190: g_excp_query_id := p_report_id;