APPS.CS_SR_DELETE_UTIL dependencies on CUG_INCIDNT_ATTR_VALS_B

Line 2871: , cug_incidnt_attr_vals_b c

2867: SELECT /*+ no_unnest no_semijoin leading(j) use_concat cardinality(10) */
2868: c.incidnt_attr_val_id
2869: FROM
2870: jtf_object_purge_param_tmp j
2871: , cug_incidnt_attr_vals_b c
2872: WHERE
2873: j.object_type = 'SR'
2874: AND p_processing_set_id = j.processing_set_id
2875: AND NVL(j.purge_status, 'S') = 'S'

Line 2900: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_B'

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

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

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

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

2924: fnd_log.string
2925: (
2926: fnd_log.level_statement
2927: , L_LOG_MODULE || 'cug_attr_b_del_end'
2928: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_B '
2929: || l_row_count || ' rows'
2930: );
2931: END IF ;
2932: