APPS.CS_KB_TRACKING_PKG SQL Statements

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

Line: 10

select count(*)
from cs_kb_session_attrs b
where b.session_id in (
    select  a.session_id
    from cs_kb_sessions a
    where a.source_object_code like 'KMT%'
    and (a.source_object_id not in
         (select session_id from icx_sessions
          where nvl(disabled_flag,'N') = 'N')));

Line: 21

select count(*)
from cs_kb_sessions a
  where a.source_object_code like 'KMT%'
  and (a.source_object_id not in
         (select session_id from icx_sessions
          where nvl(disabled_flag,'N') = 'N'));

Line: 66

  delete  cs_kb_session_attrs b
  where b.session_id in (
    select  a.session_id
    from cs_kb_sessions a
    where a.source_object_code like 'KMT%'
    and (a.source_object_id not in
         (select session_id from icx_sessions
          where nvl(disabled_flag,'N') = 'N')));

Line: 75

  delete cs_kb_sessions a
  where a.source_object_code like 'KMT%'
  and (a.source_object_id not in
         (select session_id from icx_sessions
          where nvl(disabled_flag,'N') = 'N'));