APPS.CS_SR_DELETE_UTIL dependencies on CS_HZ_SR_CONTACT_PNTS_AUDIT

Line 2344: , 'Deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT'

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

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

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

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

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