APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ANALYTICAL_SOURCES

Line 845: FROM xla_analytical_sources b

841: FOR UPDATE NOWAIT;*/
842:
843: /*CURSOR c_analytical_sources IS
844: SELECT *
845: FROM xla_analytical_sources b
846: WHERE b.amb_context_code = p_amb_context_code
847: AND EXISTS (SELECT 1
848: FROM xla_aad_header_ac_assgns xah
849: WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code

Line 2692: DELETE FROM xla_analytical_sources b

2688: p_module => l_log_module,
2689: p_level => C_LEVEL_PROCEDURE);
2690: END IF;
2691:
2692: DELETE FROM xla_analytical_sources b
2693: WHERE EXISTS (SELECT 1
2694: FROM xla_analytical_hdrs_b h
2695: WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
2696: AND b.analytical_criterion_code = h.analytical_criterion_code

Line 2702: trace(p_msg => '# xla_analytical_sources deleted = '||SQL%ROWCOUNT,

2698: AND h.amb_context_code IN (p_amb_context_code, l_staging_context_code)
2699: AND h.application_id = p_application_id);
2700:
2701: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2702: trace(p_msg => '# xla_analytical_sources deleted = '||SQL%ROWCOUNT,
2703: p_module => l_log_module,
2704: p_level => C_LEVEL_PROCEDURE);
2705: END IF;
2706: