APPS.XLA_LINE_DEFINITIONS_PVT dependencies on XLA_DESCRIPT_DETAILS_B

Line 242: FROM xla_descript_details_b d, xla_desc_priorities p

238: l_exist VARCHAR2(1);
239:
240: CURSOR c_desc_detail_sources IS
241: SELECT 'X'
242: FROM xla_descript_details_b d, xla_desc_priorities p
243: WHERE d.description_prio_id = p.description_prio_id
244: AND p.application_id = p_application_id
245: AND p.amb_context_code = p_amb_context_code
246: AND p.description_type_code = p_description_type_code

Line 301: FROM xla_descript_details_b d, xla_desc_priorities p

297: AND s.active_flag = 'Y');
298:
299: CURSOR c_desc_detail_der_sources IS
300: SELECT source_type_code, source_code
301: FROM xla_descript_details_b d, xla_desc_priorities p
302: WHERE d.description_prio_id = p.description_prio_id
303: AND p.application_id = p_application_id
304: AND p.amb_context_code = p_amb_context_code
305: AND p.description_type_code = p_description_type_code

Line 5029: FROM xla_descript_details_b xdd

5025: --
5026: CURSOR c_invalid_sources IS
5027: SELECT distinct xjl.description_type_code, xjl.description_code,
5028: xdd.source_type_code, xdd.source_code
5029: FROM xla_descript_details_b xdd
5030: ,xla_desc_priorities xdp
5031: ,xla_line_defn_jlt_assgns xjl
5032: WHERE xdd.description_prio_id = xdp.description_prio_id
5033: AND xdp.application_id = xjl.application_id

Line 5058: FROM xla_descript_details_b xdd

5054:
5055: CURSOR c_der_sources IS
5056: SELECT distinct xjl.description_type_code, xjl.description_code,
5057: xdd.source_type_code, xdd.source_code
5058: FROM xla_descript_details_b xdd
5059: ,xla_desc_priorities xdp
5060: ,xla_line_defn_jlt_assgns xjl
5061: WHERE xdd.description_prio_id = xdp.description_prio_id
5062: AND xdp.application_id = xjl.application_id

Line 7634: FROM xla_descript_details_b xdd

7630: --
7631: CURSOR c_invalid_sources IS
7632: SELECT distinct xjl.description_type_code, xjl.description_code,
7633: xdd.source_type_code, xdd.source_code
7634: FROM xla_descript_details_b xdd
7635: ,xla_desc_priorities xdp
7636: ,xla_line_defn_jlt_assgns xjl
7637: ,xla_mpa_jlt_assgns mjl
7638: WHERE xdd.description_prio_id = xdp.description_prio_id

Line 7673: FROM xla_descript_details_b xdd

7669:
7670: CURSOR c_der_sources IS
7671: SELECT distinct xjl.description_type_code, xjl.description_code,
7672: xdd.source_type_code, xdd.source_code
7673: FROM xla_descript_details_b xdd
7674: ,xla_desc_priorities xdp
7675: ,xla_line_defn_jlt_assgns xjl
7676: ,xla_mpa_jlt_assgns mjl
7677: WHERE xdd.description_prio_id = xdp.description_prio_id

Line 10606: FROM xla_descript_details_b xdd

10602: IS
10603: CURSOR c_invalid_sources IS
10604: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10605: xdd.source_type_code, xdd.source_code
10606: FROM xla_descript_details_b xdd
10607: ,xla_desc_priorities xdp
10608: ,xla_line_defn_jlt_assgns xjl
10609: WHERE xdd.description_prio_id = xdp.description_prio_id
10610: AND xdp.application_id = xjl.application_id

Line 10635: FROM xla_descript_details_b xdd

10631:
10632: CURSOR c_der_sources IS
10633: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10634: xdd.source_type_code, xdd.source_code
10635: FROM xla_descript_details_b xdd
10636: ,xla_desc_priorities xdp
10637: ,xla_line_defn_jlt_assgns xjl
10638: WHERE xdd.description_prio_id = xdp.description_prio_id
10639: AND xdp.application_id = xjl.application_id