APPS.ICX_CLEAN dependencies on ICX_SESSION_ATTRIBUTES

Line 17: delete icx_session_attributes

13: commit;
14:
15: /* Delete rows older than 12 hours */
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'))

Line 30: delete icx_session_attributes

26: where to_number(to_char(CREATION_DATE,'SSSSS'))
27: < to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60);
28: commit;
29:
30: delete icx_session_attributes
31: where session_id not in
32: (select session_id
33: from icx_sessions);
34: commit;