APPS.IGIRMINP dependencies on DUAL

Line 329: from dual;

325: |Get the length in characters of the where clause as Step 1 |
326: +---------------------------------------------------------------*/
327: select length(l_in_where_clause)
328: into l_actual_length
329: from dual;
330:
331: l_by_clause_pos := 0;
332:
333: /*--------------------------------------------------------------------+

Line 338: from dual;

334: |Strip the 'order by' clause if it is present as part of where clause|
335: +--------------------------------------------------------------------*/
336: select instr(l_in_where_clause, 'order by')
337: into l_by_clause_pos
338: from dual;
339:
340: IF (l_by_clause_pos > 0) THEN
341: l_length := l_by_clause_pos -1;
342: ELSE

Line 349: FROM DUAL;

345: |Strip the 'group by clause' if it is present as part of where clause|
346: +--------------------------------------------------------------------*/
347: SELECT INSTR(l_in_where_clause, 'group by')
348: INTO l_by_clause_pos
349: FROM DUAL;
350:
351: IF (l_by_clause_pos > 0) THEN
352: l_length := l_by_clause_pos - 1;
353: ELSE

Line 373: from dual;

369: l_temp_cell := ' ';
370: ELSE
371: select substr(l_in_where_clause, l_ctr, 1)
372: into l_temp_cell
373: from dual;
374: END IF;
375:
376: /*----------------------------------------------------------------+
377: |Check for character literals - they use the de-limiter quote |

Line 480: FROM dual;

476: IF (l_by_clause_pos > 0) THEN
477:
478: SELECT SUBSTR(l_in_where_clause, l_by_clause_pos)
479: INTO l_balance_clause
480: FROM dual;
481:
482: l_actual_where_clause := l_actual_where_clause || l_balance_clause;
483:
484: END IF; --end if by clause pos greater than 0