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 693: from dual

689: to_char(null) region_list,
690: p_region_list region_id,
691: msc_sda_utils.getRegionName(p_region_list) region_code,
692: p_region_list sort_column
693: from dual
694: where p_region_type = c_reg_view
695: and p_view_type = 1
696: union all
697: select distinct