APPS.IEM_DIAG_KB_DOC_PVT dependencies on DUAL

Line 113: select replace(v1.theme, '''', '') into l_theme from dual;

109: if v1.score>10 then
110: v1.score:=10;
111: end if;
112:
113: select replace(v1.theme, '''', '') into l_theme from dual;
114:
115: l_imt_string:=l_imt_string||'about ('||l_theme||')*'||v1.score||',';
116: l_count:=l_count+1;
117: EXIT when l_count=20; -- Top 20 Response theme from classification