APPS.CS_SR_DELETE_UTIL dependencies on CS_HZ_SR_CONTACT_PNTS_AUDIT

Line 2346: , 'Deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT'

2342: fnd_log.string
2343: (
2344: fnd_log.level_statement
2345: , L_LOG_MODULE || 'del_cont_point_aud_start'
2346: , 'Deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT'
2347: );
2348: END IF ;
2349:
2350: -- This statement deletes all the audit info attached to contacts

Line 2354: DELETE /*+ index(a) */ cs_hz_sr_contact_pnts_audit a

2350: -- This statement deletes all the audit info attached to contacts
2351: -- that are linked to an SR that is available in the global temp table
2352: -- with purge status NULL.
2353:
2354: DELETE /*+ index(a) */ cs_hz_sr_contact_pnts_audit a
2355: WHERE incident_id IN
2356: (
2357: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2358: object_id

Line 2375: , 'After deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT '

2371: fnd_log.string
2372: (
2373: fnd_log.level_statement
2374: , L_LOG_MODULE || 'del_cont_point_aud_end'
2375: , 'After deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT '
2376: || l_row_count || ' rows'
2377: );
2378: END IF ;
2379: