APPS.IEU_UWQM_TASK_WL_MIG SQL Statements

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

Line: 10

select b.importance_level, count(a.task_id) cnt
from   jtf_Tasks_b a, jtf_task_priorities_vl b
where  a.task_priority_id = b.task_priority_id
and    nvl(a.deleted_flag , 'N') = 'N'
and    a.entity = 'TASK'
and    nvl(a.open_flag, 'N') = 'Y'
and source_object_type_code <> 'SR'
group by importance_level
order by importance_level;

Line: 42

  select count(a.task_id)
  into l_null_pty_count
  from   jtf_Tasks_b a
  where a.task_priority_id is null
  and nvl(a.deleted_flag, 'N') = 'N'
  and a.entity = 'TASK'
  and nvl(a.open_flag, 'N') = 'Y';