APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_MAPPING_SET_VALUES

Line 4436: FROM xla_mapping_set_values s

4432: ,s.enabled_flag
4433: ,s.input_value_type_code
4434: ,s.input_value_constant
4435: ,C_MERGE_IMPACT_NEW merge_impact
4436: FROM xla_mapping_set_values s
4437: JOIN xla_mapping_sets_b bs
4438: ON bs.amb_context_code = s.amb_context_code
4439: AND bs.mapping_set_code = s.mapping_set_code
4440: WHERE s.amb_context_code = g_staging_context_code

Line 4443: FROM xla_mapping_set_values w

4439: AND bs.mapping_set_code = s.mapping_set_code
4440: WHERE s.amb_context_code = g_staging_context_code
4441: AND NOT EXISTS
4442: (SELECT 1
4443: FROM xla_mapping_set_values w
4444: WHERE w.amb_context_code = g_amb_context_code
4445: AND w.mapping_set_code = s.mapping_set_code
4446: AND NVL(w.value_constant,C_CHAR) = NVL(s.value_constant,C_CHAR)
4447: AND w.effective_date_from = s.effective_date_from

Line 4465: FROM xla_mapping_set_values w

4461: ,w.enabled_flag
4462: ,w.input_value_type_code
4463: ,w.input_value_constant
4464: ,C_MERGE_IMPACT_DELETED
4465: FROM xla_mapping_set_values w
4466: JOIN xla_mapping_sets_b bw
4467: ON bw.amb_context_code = w.amb_context_code
4468: AND bw.mapping_set_code = w.mapping_set_code
4469: WHERE w.amb_context_code = g_staging_context_code

Line 4472: FROM xla_mapping_set_values s

4468: AND bw.mapping_set_code = w.mapping_set_code
4469: WHERE w.amb_context_code = g_staging_context_code
4470: AND NOT EXISTS
4471: (SELECT 1
4472: FROM xla_mapping_set_values s
4473: WHERE s.amb_context_code = g_staging_context_code
4474: AND s.mapping_set_code = w.mapping_set_code
4475: AND NVL(s.value_constant,C_CHAR) = NVL(w.value_constant,C_CHAR)
4476: AND s.effective_date_from = w.effective_date_from