APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ANALYTICAL_DTLS_TL

Line 805: ,xla_analytical_dtls_tl t

801:
802: /* CURSOR c_analytical_dtls IS
803: SELECT *
804: FROM xla_analytical_dtls_b b
805: ,xla_analytical_dtls_tl t
806: WHERE t.analytical_criterion_type_code = b.analytical_criterion_type_code
807: AND t.analytical_criterion_code = b.analytical_criterion_code
808: AND t.amb_context_code = b.amb_context_code
809: AND b.amb_context_code = p_amb_context_code

Line 2707: DELETE FROM xla_analytical_dtls_tl b

2703: p_module => l_log_module,
2704: p_level => C_LEVEL_PROCEDURE);
2705: END IF;
2706:
2707: DELETE FROM xla_analytical_dtls_tl b
2708: WHERE EXISTS (SELECT 1
2709: FROM xla_analytical_hdrs_b h
2710: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
2711: AND b.analytical_criterion_code = h.analytical_criterion_code

Line 2717: trace(p_msg => '# xla_analytical_dtls_tl deleted = '||SQL%ROWCOUNT,

2713: AND h.amb_context_code IN (p_amb_context_code, l_staging_context_code)
2714: AND h.application_id = p_application_id);
2715:
2716: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2717: trace(p_msg => '# xla_analytical_dtls_tl deleted = '||SQL%ROWCOUNT,
2718: p_module => l_log_module,
2719: p_level => C_LEVEL_PROCEDURE);
2720: END IF;
2721: