APPS.XLA_LINE_DEFINITIONS_PVT dependencies on XLA_MPA_HEADER_AC_ASSGNS

Line 10967: FROM xla_mpa_header_ac_assgns xac

10963: RETURN BOOLEAN
10964: IS
10965: CURSOR c_invalid_line_ac IS
10966: SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
10967: FROM xla_mpa_header_ac_assgns xac
10968: ,xla_line_defn_jlt_assgns xjl
10969: ,xla_analytical_hdrs_b xah
10970: WHERE xah.amb_context_code = xac.amb_context_code
10971: AND xah.analytical_criterion_code = xac.analytical_criterion_code

Line 11069: FROM xla_mpa_header_ac_assgns xac

11065: RETURN BOOLEAN
11066: IS
11067: CURSOR c_invalid_line_ac IS
11068: SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
11069: FROM xla_mpa_header_ac_assgns xac
11070: ,xla_line_defn_jlt_assgns xjl
11071: ,xla_analytical_hdrs_b xah
11072: WHERE xah.amb_context_code = xac.amb_context_code
11073: AND xah.analytical_criterion_code = xac.analytical_criterion_code

Line 11171: FROM xla_mpa_header_ac_assgns xac

11167: RETURN BOOLEAN
11168: IS
11169: CURSOR c_invalid_ac IS
11170: SELECT distinct xac.analytical_criterion_type_code, xac.analytical_criterion_code
11171: FROM xla_mpa_header_ac_assgns xac
11172: ,xla_line_defn_jlt_assgns xjl
11173: WHERE xac.application_id = xjl.application_id
11174: AND xac.amb_context_code = xjl.amb_context_code
11175: AND xac.event_class_code = xjl.event_class_code

Line 11278: ,xla_mpa_header_ac_assgns xac

11274: CURSOR c_invalid_sources IS
11275: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
11276: xas.source_code, xas.source_type_code
11277: FROM xla_analytical_sources xas
11278: ,xla_mpa_header_ac_assgns xac
11279: ,xla_line_defn_jlt_assgns xjl
11280: ,xla_event_sources xes
11281: WHERE xas.application_id = xac.application_id
11282: AND xas.amb_context_code = xac.amb_context_code

Line 11315: ,xla_mpa_header_ac_assgns xac

11311: CURSOR c_der_sources IS
11312: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
11313: xas.source_code, xas.source_type_code
11314: FROM xla_analytical_sources xas
11315: ,xla_mpa_header_ac_assgns xac
11316: ,xla_line_defn_jlt_assgns xjl
11317: WHERE xas.application_id = xac.application_id
11318: AND xas.amb_context_code = xac.amb_context_code
11319: AND xas.event_class_code = xac.event_class_code

Line 11633: FROM xla_mpa_header_ac_assgns

11629: AND line_definition_owner_code = p_line_definition_owner_code
11630: AND line_definition_code = p_line_definition_code;
11631:
11632: DELETE
11633: FROM xla_mpa_header_ac_assgns
11634: WHERE application_id = p_application_id
11635: AND amb_context_code = p_amb_context_code
11636: AND event_class_code = p_event_class_code
11637: AND event_type_code = p_event_type_code

Line 11748: FROM xla_mpa_header_ac_assgns

11744: AND accounting_line_code = p_accounting_line_code;
11745:
11746: -- Added for MPA project. 4262811.
11747: DELETE
11748: FROM xla_mpa_header_ac_assgns
11749: WHERE application_id = p_application_id
11750: AND amb_context_code = p_amb_context_code
11751: AND event_class_code = p_event_class_code
11752: AND event_type_code = p_event_type_code

Line 11912: INSERT INTO xla_mpa_header_ac_assgns

11908: AND event_type_code = p_event_type_code
11909: AND line_definition_owner_code = p_old_line_defn_owner_code
11910: AND line_definition_code = p_old_line_defn_code;
11911:
11912: INSERT INTO xla_mpa_header_ac_assgns
11913: (application_id
11914: ,amb_context_code
11915: ,event_class_code
11916: ,event_type_code

Line 11946: FROM xla_mpa_header_ac_assgns

11942: ,l_created_by
11943: ,l_last_update_date
11944: ,l_last_updated_by
11945: ,l_last_update_login
11946: FROM xla_mpa_header_ac_assgns
11947: WHERE application_id = p_application_id
11948: AND amb_context_code = p_amb_context_code
11949: AND event_class_code = p_event_class_code
11950: AND event_type_code = p_event_type_code

Line 13473: INSERT INTO xla_mpa_header_ac_assgns

13469: AND accounting_line_code = p_old_accounting_line_code;
13470:
13471: If (p_mpa_option_code = 'ACCRUAL') then
13472:
13473: INSERT INTO xla_mpa_header_ac_assgns
13474: (application_id
13475: ,amb_context_code
13476: ,event_class_code
13477: ,event_type_code

Line 13507: FROM xla_mpa_header_ac_assgns

13503: ,l_created_by
13504: ,l_last_update_date
13505: ,l_last_updated_by
13506: ,l_last_update_login
13507: FROM xla_mpa_header_ac_assgns
13508: WHERE application_id = p_application_id
13509: AND amb_context_code = p_amb_context_code
13510: AND event_class_code = p_event_class_code
13511: AND event_type_code = p_event_type_code