APPS.CS_KB_TRACKING_PKG dependencies on ICX_SESSIONS

Line 17: (select session_id from icx_sessions

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')));
19:
20: cursor get_session_count is
21: select count(*)

Line 25: (select session_id from icx_sessions

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'));
27:
28:
29: l_session_attr_count number;

Line 72: (select session_id from icx_sessions

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')));
74:
75: delete cs_kb_sessions a
76: where a.source_object_code like 'KMT%'

Line 78: (select session_id from icx_sessions

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'));
80:
81: open get_session_attr_count;
82: fetch get_session_attr_count into l_session_attr_count;