APPS.CS_SR_DELETE_UTIL dependencies on CS_HZ_SR_CONTACT_POINTS

Line 2388: , 'Deleting data from table CS_HZ_SR_CONTACT_POINTS'

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

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

2392: -- This statement deletes all the contacts that are linked to an
2393: -- SR that is available in the global temp table with purge status NULL.
2394: -- Bug 10090362: Changed the hint in the sub query
2395:
2396: DELETE /*+ index(c) */ cs_hz_sr_contact_points c
2397: WHERE incident_id IN
2398: (
2399: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
2400: object_id

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

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