DBA Data[Home] [Help]

APPS.HXC_LOAD_PKG dependencies on DUAL

Line 263: from dual;

259: ' FROM ' ||
260: l_valueset_r.table_info.table_name || ' ' ||
261: l_valueset_r.table_info.where_clause
262: into l_sql_text
263: from dual;
264:
265: l_order_by_start := INSTR(upper(l_sql_text),'ORDER BY');
266: l_from_start := INSTR(upper(l_sql_text),'FROM');
267:

Line 818: from dual;

814: ' FROM ' ||
815: l_valueset_r.table_info.table_name || ' ' ||
816: l_valueset_r.table_info.where_clause
817: into l_sql_text
818: from dual;
819:
820: l_order_by_start := INSTR(upper(l_sql_text),'ORDER BY');
821: l_from_start := INSTR(upper(l_sql_text),'FROM');
822: