APPS.ECX_WORKFLOW_HTML SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 189

  SELECT queue_table INTO l_qtable
  FROM all_queues
  WHERE name = p_queue_name
AND owner IN ('APPS');

Line: 229

    l_sqlstmt := 'SELECT msgid, state, user_data FROM '||l_qtable||
                ' WHERE 100 = :b AND q_name = :c';

Line: 232

    l_sqlstmt := 'SELECT msgid, state, user_data FROM '||l_qtable||
                 ' WHERE STATE = :b AND q_name = :c';

Line: 523

  SELECT queue_table INTO l_qtable
  FROM all_queues
  WHERE name = p_queue_name
 AND owner IN ('APPS');

Line: 550

    l_sqlstmt := 'SELECT msgid, state, user_data FROM '||l_qtable||
                ' WHERE 100 = :b AND q_name = :c';

Line: 553

    l_sqlstmt := 'SELECT msgid, state, user_data FROM '||l_qtable||
                 ' WHERE STATE = :b AND q_name = :c';