APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ANALYTICAL_HDRS_TL

Line 764: ,xla_analytical_hdrs_tl t

760:
761: /*CURSOR c_analytical_hdrs IS
762: SELECT *
763: FROM xla_analytical_hdrs_b b
764: ,xla_analytical_hdrs_tl t
765: WHERE t.analytical_criterion_type_code = b.analytical_criterion_type_code
766: AND t.analytical_criterion_code = b.analytical_criterion_code
767: AND t.amb_context_code = b.amb_context_code
768: AND b.amb_context_code = p_amb_context_code

Line 2737: DELETE FROM xla_analytical_hdrs_tl b

2733: p_module => l_log_module,
2734: p_level => C_LEVEL_PROCEDURE);
2735: END IF;
2736:
2737: DELETE FROM xla_analytical_hdrs_tl b
2738: WHERE EXISTS (SELECT 1
2739: FROM xla_analytical_hdrs_b h
2740: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
2741: AND b.analytical_criterion_code = h.analytical_criterion_code

Line 2747: trace(p_msg => '# xla_analytical_hdrs_tl deleted = '||SQL%ROWCOUNT,

2743: AND h.amb_context_code IN (p_amb_context_code, l_staging_context_code)
2744: AND h.application_id = p_application_id);
2745:
2746: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2747: trace(p_msg => '# xla_analytical_hdrs_tl deleted = '||SQL%ROWCOUNT,
2748: p_module => l_log_module,
2749: p_level => C_LEVEL_PROCEDURE);
2750: END IF;
2751: