APPS.ICX_CLEAN dependencies on ICX_SESSIONS

Line 20: from icx_sessions

16:
17: delete icx_session_attributes
18: where session_id in
19: (select session_id
20: from icx_sessions
21: where to_number(to_char(CREATION_DATE,'SSSSS'))
22: < to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60));
23: commit;
24:

Line 25: delete icx_sessions

21: where to_number(to_char(CREATION_DATE,'SSSSS'))
22: < to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60));
23: commit;
24:
25: delete icx_sessions
26: where to_number(to_char(CREATION_DATE,'SSSSS'))
27: < to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60);
28: commit;
29:

Line 33: from icx_sessions);

29:
30: delete icx_session_attributes
31: where session_id not in
32: (select session_id
33: from icx_sessions);
34: commit;
35:
36: /* Delete rows older than 12 hours */
37:

Line 57: purged when ICX_SESSIONS table is purged. */

53: < to_number(to_char(SYSDATE,'SSSSS')) - (1 * 60 * 60);
54: commit;
55:
56: /* Delete rows older than 12 hours. FND_SESSION_VALUES table should be
57: purged when ICX_SESSIONS table is purged. */
58:
59: delete fnd_session_values
60: where to_number(to_char(TIMESTAMP,'SSSSS'))
61: < to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60);