APPS.CS_SR_DELETE_UTIL dependencies on CS_INCIDENTS_AUDIT_TL

Line 2603: , 'Deleting data from table CS_INCIDENTS_AUDIT_TL'

2599: fnd_log.string
2600: (
2601: fnd_log.level_statement
2602: , L_LOG_MODULE || 'del_sraudit_tl_start'
2603: , 'Deleting data from table CS_INCIDENTS_AUDIT_TL'
2604: );
2605: END IF ;
2606:
2607: -- Deleting rows from the audit TL table for the

Line 2611: DELETE /*+ index(t) */ cs_incidents_audit_tl t

2607: -- Deleting rows from the audit TL table for the
2608: -- SRs in the global temp table with purge status NULL
2609: -- Bug 10090362: Changed the hint in the sub query
2610:
2611: DELETE /*+ index(t) */ cs_incidents_audit_tl t
2612: WHERE incident_id IN
2613: (
2614: SELECT /*+ cardinality(JTF_OBJECT_PURGE_PARAM_TMP, 10) */
2615: object_id

Line 2632: , 'After deleting data from table CS_INCIDENTS_AUDIT_TL '

2628: fnd_log.string
2629: (
2630: fnd_log.level_statement
2631: , L_LOG_MODULE || 'del_sraudit_tl_end'
2632: , 'After deleting data from table CS_INCIDENTS_AUDIT_TL '
2633: || l_row_count || ' rows'
2634: );
2635: END IF ;
2636: