APPS.OKL_RULE_APIS_PVT dependencies on DUAL

Line 763: into l_add_where_clause from dual;

759: flex_query_t_rec.additional_where_clause:= REPLACE(upper(flex_query_t_rec.additional_where_clause),'WHERE',' ');
760: --dbms_output.put_line('additional where :'||flex_query_t_rec.additional_where_clause);
761: l_add_where_clause := null;
762: select l_where_clause||' '||decode(l_where_clause,null,' ',decode(instr(ltrim(flex_query_t_rec.additional_where_clause,' '),'ORDER BY'),1,' ',' AND '))||flex_query_t_rec.additional_where_clause
763: into l_add_where_clause from dual;
764: l_where_clause := l_add_where_clause;
765: End If;
766: l_query_string := rtrim(ltrim(l_select_clause,' '),' ')||' '||
767: rtrim(ltrim(l_from_clause,' '),' ')||' '||