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 7164: FROM xla_mpa_jlt_ac_assgns s

7160: , s.mpa_accounting_line_code
7161: , s.analytical_criterion_type_code
7162: , s.analytical_criterion_code
7163: , C_MERGE_IMPACT_NEW merge_impact
7164: FROM xla_mpa_jlt_ac_assgns s
7165: , xla_mpa_jlt_assgns b
7166: WHERE s.application_id = g_application_id
7167: AND s.amb_context_code = g_staging_context_code
7168: AND b.application_id = g_application_id

Line 7180: FROM xla_mpa_jlt_ac_assgns w

7176: AND b.mpa_accounting_line_type_code = s.mpa_accounting_line_type_code
7177: AND b.mpa_accounting_line_code = s.mpa_accounting_line_code
7178: AND NOT EXISTS
7179: (SELECT 1
7180: FROM xla_mpa_jlt_ac_assgns w
7181: WHERE w.application_id = g_application_id
7182: AND w.amb_context_code = g_amb_context_code
7183: AND w.event_class_code = s.event_class_code
7184: AND w.event_type_code = s.event_type_code