APPS.CS_SR_DELETE_UTIL dependencies on CS_HZ_SR_CONTACT_POINTS

Line 2386: , 'Deleting data from table CS_HZ_SR_CONTACT_POINTS'

2382: fnd_log.string
2383: (
2384: fnd_log.level_statement
2385: , L_LOG_MODULE || 'del_cont_point_start'
2386: , 'Deleting data from table CS_HZ_SR_CONTACT_POINTS'
2387: );
2388: END IF ;
2389:
2390: -- This statement deletes all the contacts that are linked to an

Line 2393: DELETE /*+ index(c) */ cs_hz_sr_contact_points c

2389:
2390: -- This statement deletes all the contacts that are linked to an
2391: -- SR that is available in the global temp table with purge status NULL.
2392:
2393: DELETE /*+ index(c) */ cs_hz_sr_contact_points c
2394: WHERE incident_id IN
2395: (
2396: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2397: object_id

Line 2413: , 'After deleting data from table CS_HZ_SR_CONTACT_POINTS '

2409: fnd_log.string
2410: (
2411: fnd_log.level_statement
2412: , L_LOG_MODULE || 'del_cont_point_end'
2413: , 'After deleting data from table CS_HZ_SR_CONTACT_POINTS '
2414: || l_row_count || ' rows'
2415: );
2416: END IF ;
2417: