APPS.CS_SR_DELETE_UTIL dependencies on CUG_INCIDNT_ATTR_VALS_B

Line 2875: , cug_incidnt_attr_vals_b c

2871: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
2872: c.incidnt_attr_val_id
2873: FROM
2874: jtf_object_purge_param_tmp j
2875: , cug_incidnt_attr_vals_b c
2876: WHERE
2877: j.object_type = 'SR'
2878: AND p_processing_set_id = j.processing_set_id
2879: AND NVL(j.purge_status, 'S') = 'S'

Line 2904: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_B'

2900: fnd_log.string
2901: (
2902: fnd_log.level_statement
2903: , L_LOG_MODULE || 'cug_attr_b_del_start'
2904: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_B'
2905: );
2906: END IF ;
2907:
2908: -- The following statement deletes all the CIC attributes that are

Line 2911: DELETE /*+ index(b) */ cug_incidnt_attr_vals_b b

2907:
2908: -- The following statement deletes all the CIC attributes that are
2909: -- linked to the SRs in the global temp table with purge_status NULL
2910:
2911: DELETE /*+ index(b) */ cug_incidnt_attr_vals_b b
2912: WHERE incident_id IN
2913: (
2914: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2915: object_id

Line 2932: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_B '

2928: fnd_log.string
2929: (
2930: fnd_log.level_statement
2931: , L_LOG_MODULE || 'cug_attr_b_del_end'
2932: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_B '
2933: || l_row_count || ' rows'
2934: );
2935: END IF ;
2936: