APPS.CS_SR_DELETE_UTIL dependencies on CS_INCIDENTS_AUDIT_B

Line 2645: , 'Deleting data from table CS_INCIDENTS_AUDIT_B'

2641: fnd_log.string
2642: (
2643: fnd_log.level_statement
2644: , L_LOG_MODULE || 'del_sraudit_b_start'
2645: , 'Deleting data from table CS_INCIDENTS_AUDIT_B'
2646: );
2647: END IF ;
2648:
2649: -- Deleting rows from the audit table for the

Line 2652: DELETE /*+ index(b) */ cs_incidents_audit_b b

2648:
2649: -- Deleting rows from the audit table for the
2650: -- SRs in the global temp table with purge status NULL
2651:
2652: DELETE /*+ index(b) */ cs_incidents_audit_b b
2653: WHERE incident_id IN
2654: (
2655: SELECT /*+ unnest no_semijoin cardinality(10) */
2656: object_id

Line 2673: , 'After deleting data from table CS_INCIDENTS_AUDIT_B '

2669: fnd_log.string
2670: (
2671: fnd_log.level_statement
2672: , L_LOG_MODULE || 'del_sraudit_b_end'
2673: , 'After deleting data from table CS_INCIDENTS_AUDIT_B '
2674: || l_row_count || ' rows'
2675: );
2676: END IF ;
2677: