DBA Data[Home] [Help]

APPS.MSC_SDA_UTILS dependencies on DUAL

Line 87: from dual;

83:
84: function getNewFormQueryId return number is
85: cursor c_query is
86: select msc_form_query_s.nextval
87: from dual;
88: l_query_id number;
89: begin
90: open c_query;
91: fetch c_query into l_query_id;

Line 99: from dual;

95:
96: function getNewAnalysisQueryId return number is
97: cursor c_query is
98: select msc_analysis_query_s.nextval
99: from dual;
100: l_query_id number;
101: begin
102: open c_query;
103: fetch c_query into l_query_id;

Line 328: from dual

324: to_char(null) region_list,
325: p_region_list region_id,
326: msc_sda_utils.getRegionName(p_region_list) region_code,
327: p_region_list sort_column
328: from dual
329: where p_region_type = c_reg_view
330: and p_view_type = 1
331: union all
332: select distinct