DBA Data[Home] [Help]

APPS.XLA_REVERSE_EVENTS_PVT_PKG dependencies on XLA_AE_HEADER_ACS

Line 316: -- Delete from xla_ae_header_acs

312: ,p_level => C_LEVEL_STATEMENT
313: ,p_module => l_log_module);
314: END IF;
315:
316: -- Delete from xla_ae_header_acs
317: DELETE FROM xla_ae_header_acs
318: WHERE ae_header_id IN
319: (SELECT /*+ leading(evt) use_nl(aeh) unnest index(aeh,XLA_AE_HEADERS_N2) */ aeh.ae_header_id
320: FROM xla_events_gt evt

Line 317: DELETE FROM xla_ae_header_acs

313: ,p_module => l_log_module);
314: END IF;
315:
316: -- Delete from xla_ae_header_acs
317: DELETE FROM xla_ae_header_acs
318: WHERE ae_header_id IN
319: (SELECT /*+ leading(evt) use_nl(aeh) unnest index(aeh,XLA_AE_HEADERS_N2) */ aeh.ae_header_id
320: FROM xla_events_gt evt
321: ,xla_ae_headers aeh

Line 823: INSERT INTO xla_ae_header_acs(

819:
820: END IF;
821:
822: -- Copy header analytical criteria FROM the original entry to the reversal entry
823: INSERT INTO xla_ae_header_acs(
824: ae_header_id
825: ,analytical_criterion_code
826: ,analytical_criterion_type_code
827: ,amb_context_code

Line 844: FROM xla_ae_header_acs xah_acs ,

840: ,xah_acs.ac3
841: ,xah_acs.ac4
842: ,xah_acs.ac5
843: ,1
844: FROM xla_ae_header_acs xah_acs ,
845: xla_ae_headers_gt xah
846: WHERE xah_acs.ae_header_id = xah.parent_header_id;
847:
848: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN