APPS.IEM_TEXT_PVT dependencies on DUAL

Line 196: select decode(p_type,1,'Y','N') into l_theme_enabled from dual;

192: where intent_id=p_intent_id
193: and query_Response='R';
194: l_flag number;
195: begin
196: select decode(p_type,1,'Y','N') into l_theme_enabled from dual;
197: l_kw_tbl.delete;
198: x_qtokens:=jtf_varchar2_Table_2000();
199: x_rtokens:=jtf_varchar2_Table_2000();
200: IF p_qtext is not null then