APPS.CS_KB_TRACKING_PKG dependencies on CS_KB_SESSIONS

Line 14: from cs_kb_sessions a

10: select count(*)
11: from cs_kb_session_attrs b
12: where b.session_id in (
13: select a.session_id
14: from cs_kb_sessions a
15: where a.source_object_code like 'KMT%'
16: and (a.source_object_id not in
17: (select session_id from icx_sessions
18: where nvl(disabled_flag,'N') = 'N')));

Line 22: from cs_kb_sessions a

18: where nvl(disabled_flag,'N') = 'N')));
19:
20: cursor get_session_count is
21: select count(*)
22: from cs_kb_sessions a
23: where a.source_object_code like 'KMT%'
24: and (a.source_object_id not in
25: (select session_id from icx_sessions
26: where nvl(disabled_flag,'N') = 'N'));

Line 69: from cs_kb_sessions a

65:
66: delete cs_kb_session_attrs b
67: where b.session_id in (
68: select a.session_id
69: from cs_kb_sessions a
70: where a.source_object_code like 'KMT%'
71: and (a.source_object_id not in
72: (select session_id from icx_sessions
73: where nvl(disabled_flag,'N') = 'N')));

Line 75: delete cs_kb_sessions a

71: and (a.source_object_id not in
72: (select session_id from icx_sessions
73: where nvl(disabled_flag,'N') = 'N')));
74:
75: delete cs_kb_sessions a
76: where a.source_object_code like 'KMT%'
77: and (a.source_object_id not in
78: (select session_id from icx_sessions
79: where nvl(disabled_flag,'N') = 'N'));