APPS.XLA_REVERSE_EVENTS_PVT_PKG dependencies on XLA_AE_LINE_ACS

Line 294: -- Delete from xla_ae_line_acs

290: ,p_level => C_LEVEL_STATEMENT
291: ,p_module => l_log_module);
292: END IF;
293:
294: -- Delete from xla_ae_line_acs
295: DELETE /*+ index(xal_acs,XLA_AE_LINE_ACS_U1) */
296: FROM xla_ae_line_acs xal_acs
297: WHERE xal_acs.ae_header_id IN
298: (SELECT/*+ leading(evt) use_nl(aeh) unnest index(aeh,XLA_AE_HEADERS_N2) */ aeh.ae_header_id

Line 295: DELETE /*+ index(xal_acs,XLA_AE_LINE_ACS_U1) */

291: ,p_module => l_log_module);
292: END IF;
293:
294: -- Delete from xla_ae_line_acs
295: DELETE /*+ index(xal_acs,XLA_AE_LINE_ACS_U1) */
296: FROM xla_ae_line_acs xal_acs
297: WHERE xal_acs.ae_header_id IN
298: (SELECT/*+ leading(evt) use_nl(aeh) unnest index(aeh,XLA_AE_HEADERS_N2) */ aeh.ae_header_id
299: FROM xla_events_gt evt

Line 296: FROM xla_ae_line_acs xal_acs

292: END IF;
293:
294: -- Delete from xla_ae_line_acs
295: DELETE /*+ index(xal_acs,XLA_AE_LINE_ACS_U1) */
296: FROM xla_ae_line_acs xal_acs
297: WHERE xal_acs.ae_header_id IN
298: (SELECT/*+ leading(evt) use_nl(aeh) unnest index(aeh,XLA_AE_HEADERS_N2) */ aeh.ae_header_id
299: FROM xla_events_gt evt
300: ,xla_ae_headers aeh

Line 1009: INSERT INTO xla_ae_line_acs(

1005: END IF;
1006:
1007: -- Copy the journal entry lines' analytical criteria from the original entry to
1008: -- the reversal entry
1009: INSERT INTO xla_ae_line_acs(
1010: ae_header_id
1011: ,ae_line_num
1012: ,analytical_criterion_code
1013: ,analytical_criterion_type_code

Line 1021: SELECT /*+ leading(xah) USE_NL_WITH_INDEX(xal_acs,XLA_AE_LINE_ACS_U1) */xah.ae_header_id

1017: ,ac3
1018: ,ac4
1019: ,ac5
1020: ,object_version_number)
1021: SELECT /*+ leading(xah) USE_NL_WITH_INDEX(xal_acs,XLA_AE_LINE_ACS_U1) */xah.ae_header_id
1022: ,xal_acs.ae_line_num
1023: ,xal_acs.analytical_criterion_code
1024: ,xal_acs.analytical_criterion_type_code
1025: ,xal_acs.amb_context_code

Line 1032: FROM xla_ae_line_acs xal_acs

1028: ,xal_acs.ac3
1029: ,xal_acs.ac4
1030: ,xal_acs.ac5
1031: ,1
1032: FROM xla_ae_line_acs xal_acs
1033: , xla_ae_headers_gt xah
1034: WHERE xal_acs.ae_header_id = xah.parent_header_id ;
1035:
1036: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN