268: ,p_level => C_LEVEL_STATEMENT
269: ,p_module => l_log_module);
270: END IF;
271:
272: -- Delete from xla_ae_segment_values
273: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
274: FROM xla_ae_segment_values
275: WHERE ae_header_id IN
276: (SELECT /*+ leading(XE) use_nl(XH) unnest index(xh,XLA_AE_HEADERS_N2) */ xh.ae_header_id
269: ,p_module => l_log_module);
270: END IF;
271:
272: -- Delete from xla_ae_segment_values
273: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
274: FROM xla_ae_segment_values
275: WHERE ae_header_id IN
276: (SELECT /*+ leading(XE) use_nl(XH) unnest index(xh,XLA_AE_HEADERS_N2) */ xh.ae_header_id
277: FROM xla_events_gt xe,
270: END IF;
271:
272: -- Delete from xla_ae_segment_values
273: DELETE /*+ index(XLA_AE_SEGMENT_VALUES, XLA_AE_SEGMENT_VALUES_U1) */
274: FROM xla_ae_segment_values
275: WHERE ae_header_id IN
276: (SELECT /*+ leading(XE) use_nl(XH) unnest index(xh,XLA_AE_HEADERS_N2) */ xh.ae_header_id
277: FROM xla_events_gt xe,
278: xla_ae_headers xh