APPS.CS_SR_DELETE_UTIL dependencies on CUG_INCIDNT_ATTR_VALS_TL

Line 2861: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_TL'

2857: fnd_log.string
2858: (
2859: fnd_log.level_statement
2860: , L_LOG_MODULE || 'cug_attr_tl_del_start'
2861: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_TL'
2862: );
2863: END IF ;
2864:
2865: -- The following statement deletes all the translatable CIC attributes that

Line 2868: DELETE /*+ index(t) */ cug_incidnt_attr_vals_tl t

2864:
2865: -- The following statement deletes all the translatable CIC attributes that
2866: -- are linked to the SRs in the global temp table with purge_status NULL
2867:
2868: DELETE /*+ index(t) */ cug_incidnt_attr_vals_tl t
2869: WHERE incidnt_attr_val_id IN
2870: (
2871: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
2872: c.incidnt_attr_val_id

Line 2891: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_TL '

2887: fnd_log.string
2888: (
2889: fnd_log.level_statement
2890: , L_LOG_MODULE || 'cug_attr_tl_del_end'
2891: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_TL '
2892: || l_row_count || ' rows'
2893: );
2894: END IF ;
2895: