APPS.XLA_REVERSE_EVENTS_PVT_PKG dependencies on XLA_AE_LINES

Line 337: -- Delete from xla_ae_lines

333: ,p_level => C_LEVEL_STATEMENT
334: ,p_module => l_log_module);
335: END IF;
336:
337: -- Delete from xla_ae_lines
338: DELETE FROM xla_ae_lines
339: WHERE application_id = g_application_id
340: AND ae_header_id IN
341: ( SELECT /*+ leading(xe) use_nl(xh) unnest index(xh,XLA_AE_HEADERS_N2) */ xh.ae_header_id

Line 338: DELETE FROM xla_ae_lines

334: ,p_module => l_log_module);
335: END IF;
336:
337: -- Delete from xla_ae_lines
338: DELETE FROM xla_ae_lines
339: WHERE application_id = g_application_id
340: AND ae_header_id IN
341: ( SELECT /*+ leading(xe) use_nl(xh) unnest index(xh,XLA_AE_HEADERS_N2) */ xh.ae_header_id
342: FROM xla_events_gt xe,

Line 857: INSERT INTO xla_ae_lines

853:
854: END IF;
855:
856: -- Create journal entry lines for the reversal journal entry
857: INSERT INTO xla_ae_lines
858: (application_id
859: ,ae_header_id
860: ,ae_line_num
861: ,displayed_line_number

Line 914: SELECT /*+ leading(xah) USE_NL_WITH_INDEX(xal,XLA_AE_LINES_U1) */

910: ,mpa_accrual_entry_flag
911: ,control_balance_flag
912: ,analytical_balance_flag
913: ,upg_batch_id ) -- 4262811
914: SELECT /*+ leading(xah) USE_NL_WITH_INDEX(xal,XLA_AE_LINES_U1) */
915: xal.application_id
916: ,xah.ae_header_id
917: ,xal.ae_line_num
918: ,xal.displayed_line_number

Line 988: FROM xla_ae_lines xal ,

984: WHERE ccid.code_combination_id = xal.code_combination_id
985: ) CONTROL_BALANCE_FLAG
986: ,DECODE(NVL(xal.analytical_balance_flag ,'N'),'N',NULL,'P')
987: , -9999
988: FROM xla_ae_lines xal ,
989: xla_ae_headers_gt xah ,
990: xla_ledger_options xlo ,
991: gl_ledgers gl
992: WHERE xal.application_id = g_application_id

Line 1063: SELECT /*+ leading(xah) USE_NL_WITH_INDEX(xal,XLA_AE_LINES_U1) */

1059: ,unrounded_entered_cr
1060: ,unrounded_accounted_dr
1061: ,unrounded_accounted_cr
1062: ,upg_batch_id )
1063: SELECT /*+ leading(xah) USE_NL_WITH_INDEX(xal,XLA_AE_LINES_U1) */
1064: xal.application_id
1065: ,xah.event_id
1066: ,xal.ae_header_id
1067: ,xal.ae_line_num

Line 1083: ,xla_ae_lines xal

1079: ,xal.unrounded_accounted_dr
1080: ,xal.unrounded_accounted_cr
1081: ,-9999
1082: FROM xla_ae_headers_gt xah
1083: ,xla_ae_lines xal
1084: WHERE 1 = 1
1085: AND xal.application_id = g_application_id
1086: AND xal.ae_header_id = xah.ae_header_id;
1087: