246: ,p_level => C_LEVEL_STATEMENT
247: ,p_module => l_log_module);
248: END IF;
249:
250: -- Delete from xla_distribution_links
251: DELETE FROM xla_distribution_links
252: WHERE ae_header_id IN
253: (SELECT /*+ leading(XE) use_nl(XH) unnest index(xh,XLA_AE_HEADERS_N2) */ xh.ae_header_id
254: FROM xla_events_gt xe,
247: ,p_module => l_log_module);
248: END IF;
249:
250: -- Delete from xla_distribution_links
251: DELETE FROM xla_distribution_links
252: WHERE ae_header_id IN
253: (SELECT /*+ leading(XE) use_nl(XH) unnest index(xh,XLA_AE_HEADERS_N2) */ xh.ae_header_id
254: FROM xla_events_gt xe,
255: xla_ae_headers xh
1040: ,p_module =>l_log_module);
1041:
1042: END IF;
1043:
1044: INSERT INTO xla_distribution_links
1045: (application_id
1046: ,event_id
1047: ,ae_header_id
1048: ,ae_line_num