DBA Data[Home] [Help]

APPS.ICX_CLEAN dependencies on ICX_FAILURES

Line 44: delete icx_failures

40: < to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60);
41:
42: /* Delete rows older than 30 days */
43:
44: delete icx_failures
45: where to_number(to_char(CREATION_DATE,'J'))
46: < to_number(to_char(SYSDATE,'J')) - 30;
47: commit;
48: