APPS.XLA_LINE_DEFINITIONS_PVT dependencies on XLA_MPA_JLT_AC_ASSGNS

Line 7911: FROM xla_mpa_jlt_ac_assgns xac

7907: RETURN BOOLEAN
7908: IS
7909: CURSOR c_invalid_line_ac IS
7910: SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
7911: FROM xla_mpa_jlt_ac_assgns xac
7912: ,xla_line_defn_jlt_assgns xjl
7913: ,xla_analytical_hdrs_b xah
7914: WHERE xah.amb_context_code = xac.amb_context_code
7915: AND xah.analytical_criterion_code = xac.analytical_criterion_code

Line 8019: FROM xla_mpa_jlt_ac_assgns xac

8015: RETURN BOOLEAN
8016: IS
8017: CURSOR c_invalid_ac IS
8018: SELECT distinct xac.analytical_criterion_type_code, xac.analytical_criterion_code
8019: FROM xla_mpa_jlt_ac_assgns xac
8020: ,xla_line_defn_jlt_assgns xjl
8021: WHERE xac.application_id = xjl.application_id
8022: AND xac.amb_context_code = xjl.amb_context_code
8023: AND xac.event_class_code = xjl.event_class_code

Line 8132: ,xla_mpa_jlt_ac_assgns xac

8128: CURSOR c_invalid_sources IS
8129: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
8130: xas.source_code, xas.source_type_code
8131: FROM xla_analytical_sources xas
8132: ,xla_mpa_jlt_ac_assgns xac
8133: ,xla_line_defn_jlt_assgns xjl
8134: ,xla_event_sources xes
8135: WHERE xas.application_id = xac.application_id
8136: AND xas.amb_context_code = xac.amb_context_code

Line 8169: ,xla_mpa_jlt_ac_assgns xac

8165: CURSOR c_der_sources IS
8166: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
8167: xas.source_code, xas.source_type_code
8168: FROM xla_analytical_sources xas
8169: ,xla_mpa_jlt_ac_assgns xac
8170: ,xla_line_defn_jlt_assgns xjl
8171: WHERE xas.application_id = xac.application_id
8172: AND xas.amb_context_code = xac.amb_context_code
8173: AND xas.event_class_code = xac.event_class_code

Line 11660: FROM xla_mpa_jlt_ac_assgns

11656: AND line_definition_owner_code = p_line_definition_owner_code
11657: AND line_definition_code = p_line_definition_code;
11658:
11659: DELETE
11660: FROM xla_mpa_jlt_ac_assgns
11661: WHERE application_id = p_application_id
11662: AND amb_context_code = p_amb_context_code
11663: AND event_class_code = p_event_class_code
11664: AND event_type_code = p_event_type_code

Line 11781: FROM xla_mpa_jlt_ac_assgns

11777: AND accounting_line_type_code = p_accounting_line_type_code
11778: AND accounting_line_code = p_accounting_line_code;
11779:
11780: DELETE
11781: FROM xla_mpa_jlt_ac_assgns
11782: WHERE application_id = p_application_id
11783: AND amb_context_code = p_amb_context_code
11784: AND event_class_code = p_event_class_code
11785: AND event_type_code = p_event_type_code

Line 12331: INSERT INTO xla_mpa_jlt_ac_assgns

12327: AND event_type_code = p_event_type_code
12328: AND line_definition_owner_code = p_old_line_defn_owner_code
12329: AND line_definition_code = p_old_line_defn_code;
12330:
12331: INSERT INTO xla_mpa_jlt_ac_assgns
12332: (application_id
12333: ,amb_context_code
12334: ,event_class_code
12335: ,event_type_code

Line 12371: FROM xla_mpa_jlt_ac_assgns

12367: ,l_created_by
12368: ,l_last_update_date
12369: ,l_last_updated_by
12370: ,l_last_update_login
12371: FROM xla_mpa_jlt_ac_assgns
12372: WHERE application_id = p_application_id
12373: AND amb_context_code = p_amb_context_code
12374: AND event_class_code = p_event_class_code
12375: AND event_type_code = p_event_type_code

Line 13518: INSERT INTO xla_mpa_jlt_ac_assgns

13514: AND accounting_line_type_code = p_old_accting_line_type_code
13515: AND accounting_line_code = p_old_accounting_line_code;
13516:
13517:
13518: INSERT INTO xla_mpa_jlt_ac_assgns
13519: (application_id
13520: ,amb_context_code
13521: ,event_class_code
13522: ,event_type_code

Line 13558: FROM xla_mpa_jlt_ac_assgns

13554: ,l_created_by
13555: ,l_last_update_date
13556: ,l_last_updated_by
13557: ,l_last_update_login
13558: FROM xla_mpa_jlt_ac_assgns
13559: WHERE application_id = p_application_id
13560: AND amb_context_code = p_amb_context_code
13561: AND event_class_code = p_event_class_code
13562: AND event_type_code = p_event_type_code

Line 14212: FROM xla_mpa_jlt_ac_assgns

14208: AND mpa_accounting_line_type_code = p_mpa_accounting_line_type_co
14209: AND mpa_accounting_line_code = p_mpa_accounting_line_code;
14210:
14211: DELETE
14212: FROM xla_mpa_jlt_ac_assgns
14213: WHERE application_id = p_application_id
14214: AND amb_context_code = p_amb_context_code
14215: AND event_class_code = p_event_class_code
14216: AND event_type_code = p_event_type_code