APPS.XLA_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_MPA_JLT_AC_ASSGNS

Line 2972: FROM xla_mpa_jlt_ac_assgns w

2968: , w.accounting_line_type_code
2969: , w.accounting_line_code
2970: , w.mpa_accounting_line_type_code
2971: , w.mpa_accounting_line_code
2972: FROM xla_mpa_jlt_ac_assgns w
2973: , xla_mpa_jlt_assgns b
2974: WHERE b.amb_context_code = g_staging_context_code
2975: AND b.application_id = g_application_id
2976: AND b.event_class_code = w.event_class_code

Line 3158: FROM xla_mpa_jlt_ac_assgns w

3154: , w.accounting_line_type_code
3155: , w.accounting_line_code
3156: , w.mpa_accounting_line_type_code
3157: , w.mpa_accounting_line_code
3158: FROM xla_mpa_jlt_ac_assgns w
3159: LEFT OUTER JOIN xla_mpa_jlt_assgns s
3160: ON s.amb_context_code = g_staging_context_code
3161: AND s.event_class_code = w.event_class_code
3162: AND s.event_type_code = w.event_type_code

Line 7154: FROM xla_mpa_jlt_ac_assgns s

7150: , s.mpa_accounting_line_code
7151: , s.analytical_criterion_type_code
7152: , s.analytical_criterion_code
7153: , C_MERGE_IMPACT_NEW merge_impact
7154: FROM xla_mpa_jlt_ac_assgns s
7155: , xla_mpa_jlt_assgns b
7156: WHERE s.application_id = g_application_id
7157: AND s.amb_context_code = g_staging_context_code
7158: AND b.application_id = g_application_id

Line 7170: FROM xla_mpa_jlt_ac_assgns w

7166: AND b.mpa_accounting_line_type_code = s.mpa_accounting_line_type_code
7167: AND b.mpa_accounting_line_code = s.mpa_accounting_line_code
7168: AND NOT EXISTS
7169: (SELECT 1
7170: FROM xla_mpa_jlt_ac_assgns w
7171: WHERE w.application_id = g_application_id
7172: AND w.amb_context_code = g_amb_context_code
7173: AND w.event_class_code = s.event_class_code
7174: AND w.event_type_code = s.event_type_code