The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'x'
FROM xla_analytical_sources a
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND analytical_criterion_code = p_ac_code
AND analytical_criterion_type_code = p_ac_type_code;
SELECT 'X'
FROM xla_analytical_sources a
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND analytical_criterion_code = p_ac_code
AND analytical_criterion_type_code = p_ac_type_code
AND source_type_code = 'S'
AND not exists (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = a.source_application_id
AND s.source_type_code = a.source_type_code
AND s.source_code = a.source_code
AND s.application_id = p_application_id
AND s.entity_code = p_entity_code
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y');
SELECT source_code, source_type_code
FROM xla_analytical_sources a
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND entity_code = p_entity_code
AND event_class_code = p_event_class_code
AND analytical_criterion_code = p_ac_code
AND analytical_criterion_type_code = p_ac_type_code
AND a.source_type_code = 'D';
SELECT 'X'
FROM xla_descript_details_b d, xla_desc_priorities p
WHERE d.description_prio_id = p.description_prio_id
AND p.application_id = p_application_id
AND p.amb_context_code = p_amb_context_code
AND p.description_type_code = p_description_type_code
AND p.description_code = p_description_code
AND d.source_code IS NOT NULL
AND d.source_type_code = 'S'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = d.source_application_id
AND s.source_type_code = d.source_type_code
AND s.source_code = d.source_code
AND s.application_id = p_application_id
AND s.entity_code = p_entity_code
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y');
SELECT 'X'
FROM xla_conditions c, xla_desc_priorities d
WHERE c.description_prio_id = d.description_prio_id
AND d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.description_type_code = p_description_type_code
AND d.description_code = p_description_code
AND c.source_code IS NOT NULL
AND c.source_type_code = 'S'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = c.source_application_id
AND s.source_type_code = c.source_type_code
AND s.source_code = c.source_code
AND s.application_id = p_application_id
AND s.entity_code = p_entity_code
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y')
UNION
SELECT 'X' source_code
FROM xla_conditions c, xla_desc_priorities d
WHERE c.description_prio_id = d.description_prio_id
AND d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.description_type_code = p_description_type_code
AND d.description_code = p_description_code
AND c.value_source_code IS NOT NULL
AND c.value_source_type_code = 'S'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = c.value_source_application_id
AND s.source_type_code = c.value_source_type_code
AND s.source_code = c.value_source_code
AND s.application_id = p_application_id
AND s.entity_code = p_entity_code
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y');
SELECT source_type_code, source_code
FROM xla_descript_details_b d, xla_desc_priorities p
WHERE d.description_prio_id = p.description_prio_id
AND p.application_id = p_application_id
AND p.amb_context_code = p_amb_context_code
AND p.description_type_code = p_description_type_code
AND p.description_code = p_description_code
AND d.source_code IS NOT NULL
AND d.source_type_code = 'D';
SELECT source_type_code source_type_code, source_code source_code
FROM xla_conditions c, xla_desc_priorities d
WHERE c.description_prio_id = d.description_prio_id
AND d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.description_type_code = p_description_type_code
AND d.description_code = p_description_code
AND c.source_code IS NOT NULL
AND c.source_type_code = 'D'
UNION
SELECT value_source_type_code source_type_code, value_source_code source_code
FROM xla_conditions c, xla_desc_priorities d
WHERE c.description_prio_id = d.description_prio_id
AND d.application_id = p_application_id
AND d.amb_context_code = p_amb_context_code
AND d.description_type_code = p_description_type_code
AND d.description_code = p_description_code
AND c.value_source_code IS NOT NULL
AND c.value_source_type_code = 'D';
SELECT 'x'
FROM xla_seg_rule_details d
WHERE application_id = NVL(p_segment_rule_appl_id
,p_application_id)
AND amb_context_code = p_amb_context_code
AND segment_rule_type_code = p_segment_rule_type_code
AND segment_rule_code = p_segment_rule_code;
SELECT 'x'
FROM xla_seg_rule_details d
WHERE application_id = NVL(p_segment_rule_appl_id
,p_application_id)
AND amb_context_code = p_amb_context_code
AND segment_rule_type_code = p_segment_rule_type_code
AND segment_rule_code = p_segment_rule_code
AND value_source_code IS NOT NULL
AND value_source_type_code = 'S'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = d.value_source_application_id
AND s.source_type_code = d.value_source_type_code
AND s.source_code = d.value_source_code
AND s.application_id = p_application_id
AND s.entity_code = p_entity_code
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y')
UNION
SELECT 'x'
FROM xla_seg_rule_details d
WHERE application_id = NVL(p_segment_rule_appl_id
,p_application_id)
AND amb_context_code = p_amb_context_code
AND segment_rule_type_code = p_segment_rule_type_code
AND segment_rule_code = p_segment_rule_code
AND input_source_code IS NOT NULL
AND input_source_type_code = 'S'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = d.input_source_application_id
AND s.source_type_code = d.input_source_type_code
AND s.source_code = d.input_source_code
AND s.application_id = p_application_id
AND s.entity_code = p_entity_code
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y');
SELECT 'x'
FROM xla_conditions c, xla_seg_rule_details d
WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
AND d.application_id = NVL(p_segment_rule_appl_id
,p_application_id)
AND d.amb_context_code = p_amb_context_code
AND d.segment_rule_type_code = p_segment_rule_type_code
AND d.segment_rule_code = p_segment_rule_code
AND c.source_code IS NOT NULL
AND c.source_type_code = 'S'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = c.source_application_id
AND s.source_type_code = c.source_type_code
AND s.source_code = c.source_code
AND s.application_id = p_application_id
AND s.entity_code = p_entity_code
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y')
UNION
SELECT 'x'
FROM xla_conditions c, xla_seg_rule_details d
WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
AND d.application_id = NVL(p_segment_rule_appl_id
,p_application_id)
AND d.amb_context_code = p_amb_context_code
AND d.segment_rule_type_code = p_segment_rule_type_code
AND d.segment_rule_code = p_segment_rule_code
AND c.value_source_code IS NOT NULL
AND c.value_source_type_code = 'S'
AND NOT EXISTS (SELECT 'y'
FROM xla_event_sources s
WHERE s.source_application_id = c.value_source_application_id
AND s.source_type_code = c.value_source_type_code
AND s.source_code = c.value_source_code
AND s.application_id = p_application_id
AND s.entity_code = p_entity_code
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y');
SELECT value_source_type_code source_type_code, value_source_code source_code
FROM xla_seg_rule_details d
WHERE application_id = NVL(p_segment_rule_appl_id,
p_application_id)
AND amb_context_code = p_amb_context_code
AND segment_rule_type_code = p_segment_rule_type_code
AND segment_rule_code = p_segment_rule_code
AND value_source_code IS NOT NULL
AND value_source_type_code = 'D'
UNION
SELECT input_source_type_code source_type_code, input_source_code source_code
FROM xla_seg_rule_details d
WHERE application_id = NVL(p_segment_rule_appl_id,
p_application_id)
AND amb_context_code = p_amb_context_code
AND segment_rule_type_code = p_segment_rule_type_code
AND segment_rule_code = p_segment_rule_code
AND input_source_code IS NOT NULL
AND input_source_type_code = 'D';
SELECT c.source_type_code source_type_code, c.source_code source_code
FROM xla_conditions c, xla_seg_rule_details d
WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
AND d.application_id = NVL(p_segment_rule_appl_id
,p_application_id)
AND d.amb_context_code = p_amb_context_code
AND d.segment_rule_type_code = p_segment_rule_type_code
AND d.segment_rule_code = p_segment_rule_code
AND c.source_code IS NOT NULL
AND c.source_type_code = 'D'
UNION
SELECT c.value_source_type_code source_type_code, c.value_source_code source_code
FROM xla_conditions c, xla_seg_rule_details d
WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
AND d.application_id = NVL(p_segment_rule_appl_id
,p_application_id)
AND d.amb_context_code = p_amb_context_code
AND d.segment_rule_type_code = p_segment_rule_type_code
AND d.segment_rule_code = p_segment_rule_code
AND c.value_source_code IS NOT NULL
AND c.value_source_type_code = 'D';
SELECT distinct xlj.accounting_line_type_code, xlj.accounting_line_code
FROM xla_line_defn_jlt_assgns xlj
, xla_acct_line_types_b xalt
, xla_line_defn_adr_assgns xld
WHERE xlj.application_id = p_application_id
AND xlj.amb_context_code = p_amb_context_code
AND xlj.event_class_code = p_event_class_code
AND xlj.event_type_code = p_event_type_code
AND xlj.line_definition_owner_code = p_line_definition_owner_code
AND xlj.line_definition_code = p_line_definition_code
AND xalt.accounting_line_type_code = xlj.accounting_line_type_code
AND xalt.accounting_line_code = xlj.accounting_line_code
AND xalt.event_class_code = xlj.event_class_code
AND xalt.application_id = xlj.application_id
AND xalt.amb_context_code = xlj.amb_context_code
AND xlj.application_id = xld.application_id
AND xlj.amb_context_code = xld.amb_context_code
AND xlj.event_class_code = xld.event_class_code
AND xlj.event_type_code = xld.event_type_code
AND xlj.line_definition_owner_code = xld.line_definition_owner_code
AND xlj.line_definition_code = xld.line_definition_code
AND xlj.accounting_line_type_code = xld.accounting_line_type_code
AND xlj.accounting_line_code = xld.accounting_line_code
AND ((xalt.natural_side_code = 'G' AND xld.side_code ='NA')
OR (xalt.natural_side_code <>'G' AND xld.side_code <> 'NA'));
SELECT xld.accounting_coa_id
FROM xla_line_definitions_b xld
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code;
SELECT distinct xlj.accounting_line_type_code, xlj.accounting_line_code
FROM xla_line_defn_jlt_assgns xlj
,xla_acct_line_types_b jlt
WHERE xlj.application_id = p_application_id
AND xlj.amb_context_code = p_amb_context_code
AND xlj.event_class_code = p_event_class_code
AND xlj.event_type_code = p_event_type_code
AND xlj.line_definition_owner_code = p_line_definition_owner_code
AND xlj.line_definition_code = p_line_definition_code
AND xlj.active_flag = 'Y'
AND xlj.application_id = jlt.application_id
AND xlj.amb_context_code = jlt.amb_context_code
AND xlj.event_class_code = jlt.event_class_code
AND xlj.accounting_line_type_code = jlt.accounting_line_type_code
AND xlj.accounting_line_code = jlt.accounting_line_code
AND jlt.business_method_code <> 'PRIOR_ENTRY'
AND NOT EXISTS
(SELECT 1 FROM xla_line_defn_adr_assgns xad1
WHERE xlj.application_id = xad1.application_id
AND xlj.amb_context_code = xad1.amb_context_code
AND xlj.event_class_code = xad1.event_class_code
AND xlj.event_type_code = xad1.event_type_code
AND xlj.line_definition_owner_code = xad1.line_definition_owner_code
AND xlj.line_definition_code = xad1.line_definition_code
AND xlj.accounting_line_type_code = xad1.accounting_line_type_code
AND xlj.accounting_line_code = xad1.accounting_line_code);
SELECT distinct xlj.accounting_line_type_code, xlj.accounting_line_code
FROM xla_line_defn_jlt_assgns xlj
--,xla_acct_line_types_b jlt
WHERE xlj.application_id = p_application_id
AND xlj.amb_context_code = p_amb_context_code
AND xlj.event_class_code = p_event_class_code
AND xlj.event_type_code = p_event_type_code
AND xlj.line_definition_owner_code = p_line_definition_owner_code
AND xlj.line_definition_code = p_line_definition_code
AND xlj.active_flag = 'Y'
--AND xlj.application_id = jlt.application_id
--AND xlj.amb_context_code = jlt.amb_context_code
--AND xlj.event_class_code = jlt.event_class_code
--AND xlj.accounting_line_type_code = jlt.accounting_line_type_code
--AND xlj.accounting_line_code = jlt.accounting_line_code
--AND jlt.business_method_code <> 'PRIOR_ENTRY'
AND EXISTS (SELECT 1 FROM xla_line_defn_adr_assgns xad1
WHERE xlj.application_id = xad1.application_id
AND xlj.amb_context_code = xad1.amb_context_code
AND xlj.event_class_code = xad1.event_class_code
AND xlj.event_type_code = xad1.event_type_code
AND xlj.line_definition_owner_code = xad1.line_definition_owner_code
AND xlj.line_definition_code = xad1.line_definition_code
AND xlj.accounting_line_type_code = xad1.accounting_line_type_code
AND xlj.accounting_line_code = xad1.accounting_line_code )
AND 2<>
(SELECT nvl(sum(decode(side_code, 'ALL', 2, 'NA', 2, 1)), 0)
FROM xla_line_defn_adr_assgns xad
WHERE xlj.application_id = xad.application_id
AND xlj.amb_context_code = xad.amb_context_code
AND xlj.event_class_code = xad.event_class_code
AND xlj.event_type_code = xad.event_type_code
AND xlj.line_definition_owner_code = xad.line_definition_owner_code
AND xlj.line_definition_code = xad.line_definition_code
AND xlj.accounting_line_type_code = xad.accounting_line_type_code
AND xlj.accounting_line_code = xad.accounting_line_code
AND xad.flexfield_segment_code = 'ALL');
SELECT distinct xlj.accounting_line_type_code, xlj.accounting_line_code
FROM xla_line_defn_jlt_assgns xlj
,fnd_id_flex_segments_vl fif
-- , xla_acct_line_types_b jlt
WHERE fif.application_id = 101
AND fif.id_flex_code = 'GL#'
AND fif.id_flex_num = l_coa_id
AND fif.enabled_flag = 'Y'
AND xlj.application_id = p_application_id
AND xlj.amb_context_code = p_amb_context_code
AND xlj.event_class_code = p_event_class_code
AND xlj.event_type_code = p_event_type_code
AND xlj.line_definition_owner_code = p_line_definition_owner_code
AND xlj.line_definition_code = p_line_definition_code
AND xlj.active_flag = 'Y'
-- AND xlj.application_id = jlt.application_id
-- AND xlj.amb_context_code = jlt.amb_context_code
-- AND xlj.event_class_code = jlt.event_class_code
-- AND xlj.accounting_line_type_code = jlt.accounting_line_type_code
-- AND xlj.accounting_line_code = jlt.accounting_line_code
-- AND jlt.business_method_code <> 'PRIOR_ENTRY' -- Bug 4922099
AND EXISTS (SELECT 1 FROM xla_line_defn_adr_assgns xad1
WHERE xlj.application_id = xad1.application_id
AND xlj.amb_context_code = xad1.amb_context_code
AND xlj.event_class_code = xad1.event_class_code
AND xlj.event_type_code = xad1.event_type_code
AND xlj.line_definition_owner_code = xad1.line_definition_owner_code
AND xlj.line_definition_code = xad1.line_definition_code
AND xlj.accounting_line_type_code = xad1.accounting_line_type_code
AND xlj.accounting_line_code = xad1.accounting_line_code )
AND (
(NOT EXISTS
(SELECT 'Y'
FROM xla_line_defn_adr_assgns xad
WHERE xlj.application_id = xad.application_id
AND xlj.amb_context_code = xad.amb_context_code
AND xlj.event_class_code = xad.event_class_code
AND xlj.event_type_code = xad.event_type_code
AND xlj.line_definition_owner_code = xad.line_definition_owner_code
AND xlj.line_definition_code = xad.line_definition_code
AND xlj.accounting_line_type_code = xad.accounting_line_type_code
AND xlj.accounting_line_code = xad.accounting_line_code
AND xad.flexfield_segment_code = fif.application_column_name
AND xad.side_code in ('NA', 'CREDIT', 'ALL'))
AND NOT EXISTS
(SELECT 'Y'
FROM xla_line_defn_adr_assgns xad
WHERE xlj.application_id = xad.application_id
AND xlj.amb_context_code = xad.amb_context_code
AND xlj.event_class_code = xad.event_class_code
AND xlj.event_type_code = xad.event_type_code
AND xlj.line_definition_owner_code = xad.line_definition_owner_code
AND xlj.line_definition_code = xad.line_definition_code
AND xlj.accounting_line_type_code = xad.accounting_line_type_code
AND xlj.accounting_line_code = xad.accounting_line_code
AND xad.flexfield_segment_code = 'ALL'
AND xad.side_code in ('NA', 'CREDIT', 'ALL')))
OR ( NOT EXISTS
(SELECT 'Y'
FROM xla_line_defn_adr_assgns xad
WHERE xlj.application_id = xad.application_id
AND xlj.amb_context_code = xad.amb_context_code
AND xlj.event_class_code = xad.event_class_code
AND xlj.event_type_code = xad.event_type_code
AND xlj.line_definition_owner_code = xad.line_definition_owner_code
AND xlj.line_definition_code = xad.line_definition_code
AND xlj.accounting_line_type_code = xad.accounting_line_type_code
AND xlj.accounting_line_code = xad.accounting_line_code
AND xad.flexfield_segment_code = fif.application_column_name
AND xad.side_code in ('NA', 'DEBIT', 'ALL'))
AND NOT EXISTS
(SELECT 'Y'
FROM xla_line_defn_adr_assgns xad
WHERE xlj.application_id = xad.application_id
AND xlj.amb_context_code = xad.amb_context_code
AND xlj.event_class_code = xad.event_class_code
AND xlj.event_type_code = xad.event_type_code
AND xlj.line_definition_owner_code = xad.line_definition_owner_code
AND xlj.line_definition_code = xad.line_definition_code
AND xlj.accounting_line_type_code = xad.accounting_line_type_code
AND xlj.accounting_line_code = xad.accounting_line_code
AND xad.flexfield_segment_code = 'ALL'
AND xad.side_code in ('NA', 'DEBIT', 'ALL'))));
SELECT distinct xsr.segment_rule_type_code, xsr.segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_line_defn_adr_assgns xad
,xla_seg_rules_b xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.enabled_flag <> 'Y'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xsr.application_id, xsr.amb_context_code,
xsr.segment_rule_type_code, xsr.segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_line_defn_adr_assgns xad
,xla_seg_rules_b xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT xsd.value_segment_rule_type_code, xsd.value_segment_rule_code
FROM xla_seg_rule_details xsd
,xla_seg_rules_b xsr
WHERE xsd.application_id = l_adr.application_id
AND xsd.amb_context_code = l_adr.amb_context_code
AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code
AND xsd.segment_rule_code = l_adr.segment_rule_code
AND xsd.value_type_code = 'A'
AND xsd.value_segment_rule_appl_id = xsr.application_id
AND xsd.value_segment_rule_type_code = xsr.segment_rule_type_code
AND xsd.value_segment_rule_code = xsr.segment_rule_code
AND xsd.amb_context_code = xsr.amb_context_code
AND xsr.enabled_flag <> 'Y';
SELECT distinct xad.segment_rule_code, xad.segment_rule_type_code
FROM xla_line_defn_adr_assgns xad, xla_line_defn_jlt_assgns xjl
WHERE xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xad.segment_rule_code is not null
AND NOT EXISTS
(SELECT 'x'
FROM xla_seg_rule_details xsr
WHERE xsr.application_id = NVL(xad.segment_rule_appl_id,xad.application_id)
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code);
SELECT distinct xsr.application_id, xsr.amb_context_code,
xsr.segment_rule_type_code, xsr.segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_line_defn_adr_assgns xad
,xla_seg_rules_b xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT xsd.value_segment_rule_type_code, xsd.value_segment_rule_code
FROM xla_seg_rule_details xsd
WHERE xsd.application_id = l_adr.application_id
AND xsd.amb_context_code = l_adr.amb_context_code
AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code
AND xsd.segment_rule_code = l_adr.segment_rule_code
AND xsd.value_type_code = 'A'
AND not exists (SELECT 'x'
FROM xla_seg_rule_details xcd
WHERE xcd.application_id = xsd.value_segment_rule_appl_id
AND xcd.amb_context_code = xsd.amb_context_code
AND xcd.segment_rule_type_code = xsd.value_segment_rule_type_code
AND xcd.segment_rule_code = xsd.value_segment_rule_code);
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.source_type_code, xco.source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
,xla_line_defn_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xco.source_type_code = 'S'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.source_application_id
AND xes.source_type_code = xco.source_type_code
AND xes.source_code = xco.source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
,xla_line_defn_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xco.value_source_type_code = 'S'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.value_source_application_id
AND xes.source_type_code = xco.value_source_type_code
AND xes.source_code = xco.value_source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.source_type_code source_type_code, xco.source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
,xla_line_defn_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xco.source_type_code = 'D'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
,xla_line_defn_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xco.value_source_type_code = 'D'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xsr.segment_rule_type_code, xsr.segment_rule_code,
xsr.value_segment_rule_appl_id,
xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_line_defn_adr_assgns xad
,xla_seg_rule_details xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_type_code = 'A'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.source_type_code, xco.source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xco.source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.source_application_id
AND xes.source_type_code = xco.source_type_code
AND xes.source_code = xco.source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xco.value_source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.value_source_application_id
AND xes.source_type_code = xco.value_source_type_code
AND xes.source_code = xco.value_source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.source_type_code source_type_code, xco.source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xco.source_type_code = 'D'
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xco.value_source_type_code = 'D';
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
FROM xla_seg_rule_details xsr
,xla_line_defn_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_source_type_code = 'S'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xsr.value_source_application_id
AND xes.source_type_code = xsr.value_source_type_code
AND xes.source_code = xsr.value_source_code
AND xes.application_id = xsr.application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
FROM xla_seg_rule_details xsr
,xla_line_defn_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.input_source_type_code = 'S'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xsr.input_source_application_id
AND xes.source_type_code = xsr.input_source_type_code
AND xes.source_code = xsr.input_source_code
AND xes.application_id = xsr.application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
FROM xla_seg_rule_details xsr
,xla_line_defn_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_source_type_code = 'D'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
FROM xla_seg_rule_details xsr
,xla_line_defn_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.input_source_type_code = 'D'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xsr.segment_rule_type_code, xsr.segment_rule_code,
xsr.value_segment_rule_appl_id,
xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_line_defn_adr_assgns xad
,xla_seg_rule_details xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_type_code = 'A'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
FROM xla_seg_rule_details xsr
WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xsr.value_source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xsr.value_source_application_id
AND xes.source_type_code = xsr.value_source_type_code
AND xes.source_code = xsr.value_source_code
AND xes.application_id = xsr.application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
FROM xla_seg_rule_details xsr
WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xsr.input_source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xsr.input_source_application_id
AND xes.source_type_code = xsr.input_source_type_code
AND xes.source_code = xsr.input_source_code
AND xes.application_id = xsr.application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
FROM xla_seg_rule_details xsr
WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xsr.value_source_type_code = 'D'
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
FROM xla_seg_rule_details xsr
WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xsr.input_source_type_code = 'D';
SELECT 'X'
FROM xla_line_defn_jlt_assgns xld
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y';
SELECT distinct event_class_code, event_type_code,
accounting_line_type_code, accounting_line_code
FROM xla_line_defn_jlt_assgns xld
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'y'
FROM xla_acct_line_types_b xal
WHERE xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.enabled_flag = 'Y');
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code
FROM xla_line_defn_jlt_assgns xld
, xla_acct_line_types_b xal
WHERE xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.enabled_flag = 'Y'
AND xal.accounting_entry_type_code = 'E'
AND NVL(xal.business_method_code,'NONE') <> 'PRIOR_ENTRY'
AND xal.encumbrance_type_id IS NULL
AND xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y';
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code
FROM xla_line_defn_jlt_assgns xld
, xla_acct_line_types_b xal
WHERE xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.enabled_flag = 'Y'
AND xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'y'
FROM xla_lookups xlk
WHERE xlk.lookup_type = 'XLA_ACCOUNTING_CLASS'
AND xlk.lookup_code = xal.accounting_class_code);
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code
FROM xla_line_defn_jlt_assgns xld
, xla_acct_line_types_b xal
WHERE xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.enabled_flag = 'Y'
AND xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'y'
FROM xla_lookups xlk
WHERE xlk.lookup_type = 'XLA_ACCOUNTING_CLASS'
AND xlk.lookup_code = xal.rounding_class_code);
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code
FROM xla_line_defn_jlt_assgns xld
, xla_acct_line_types_b xal
WHERE xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.enabled_flag = 'Y'
AND xal.business_class_code IS NOT NULL
AND xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'y'
FROM xla_lookups xlk
WHERE xlk.lookup_type = 'XLA_BUSINESS_FLOW_CLASS'
AND xlk.lookup_code = xal.business_class_code);
SELECT distinct event_class_code, event_type_code,
accounting_line_type_code, accounting_line_code
FROM xla_line_defn_jlt_assgns xld
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.inherit_desc_flag = 'Y'
AND EXISTS
(SELECT 'y'
FROM xla_acct_line_types_b xal
WHERE xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.business_method_code = 'NONE');
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code
FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.business_method_code = 'PRIOR_ENTRY'
AND EXISTS
(SELECT 'y'
FROM xla_line_defn_adr_assgns adr
WHERE adr.application_id = xld.application_id
AND adr.amb_context_code = xld.amb_context_code
AND adr.event_class_code = xld.event_class_code
AND adr.event_type_code = xld.event_type_code
AND adr.line_definition_owner_code = xld.line_definition_owner_code
AND adr.line_definition_code = xld.line_definition_code
AND adr.accounting_line_type_code = xld.accounting_line_type_code
AND adr.accounting_line_code = xld.accounting_line_code);
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code
FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.business_method_code = 'PRIOR_ENTRY'
AND EXISTS
(SELECT 'y'
FROM xla_line_defn_ac_assgns adr
WHERE adr.application_id = xld.application_id
AND adr.amb_context_code = xld.amb_context_code
AND adr.event_class_code = xld.event_class_code
AND adr.event_type_code = xld.event_type_code
AND adr.line_definition_owner_code = xld.line_definition_owner_code
AND adr.line_definition_code = xld.line_definition_code
AND adr.accounting_line_type_code = xld.accounting_line_type_code
AND adr.accounting_line_code = xld.accounting_line_code);
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code
FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.business_method_code = 'NONE'
AND EXISTS
(SELECT 'y'
FROM xla_line_defn_adr_assgns adr
WHERE adr.application_id = xld.application_id
AND adr.amb_context_code = xld.amb_context_code
AND adr.event_class_code = xld.event_class_code
AND adr.event_type_code = xld.event_type_code
AND adr.line_definition_owner_code = xld.line_definition_owner_code
AND adr.line_definition_code = xld.line_definition_code
AND adr.accounting_line_type_code = xld.accounting_line_type_code
AND adr.accounting_line_code = xld.accounting_line_code
AND adr.inherit_adr_flag = 'Y');
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code
FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.business_class_code IS NOT NULL
AND NOT EXISTS
(SELECT 'y'
FROM xla_lookups lkp
WHERE lkp.lookup_code = xal.business_class_code
AND lkp.lookup_type = 'XLA_BUSINESS_FLOW_CLASS'
AND lkp.enabled_flag = 'Y'
AND lkp.end_date_active IS NULL);
SELECT 'x'
FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.business_method_code = 'SAME_ENTRY'
AND xal.natural_side_code = 'D';
SELECT 'x'
FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xal.application_id = xld.application_id
AND xal.amb_context_code = xld.amb_context_code
AND xal.event_class_code = xld.event_class_code
AND xal.accounting_line_type_code = xld.accounting_line_type_code
AND xal.accounting_line_code = xld.accounting_line_code
AND xal.business_method_code = 'SAME_ENTRY'
AND xal.natural_side_code = 'C';
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code,
xco.source_type_code, xco.source_code
FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xco.application_id = xld.application_id
AND xco.amb_context_code = xld.amb_context_code
AND xco.event_class_code = xld.event_class_code
AND xco.accounting_line_type_code = xld.accounting_line_type_code
AND xco.accounting_line_code = xld.accounting_line_code
AND xco.source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.source_application_id
AND xes.source_type_code = xco.source_type_code
AND xes.source_code = xco.source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xco.application_id = xld.application_id
AND xco.amb_context_code = xld.amb_context_code
AND xco.event_class_code = xld.event_class_code
AND xco.accounting_line_type_code = xld.accounting_line_type_code
AND xco.accounting_line_code = xld.accounting_line_code
AND xco.value_source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.value_source_application_id
AND xes.source_type_code = xco.value_source_type_code
AND xes.source_code = xco.value_source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code,
xco.source_type_code, xco.source_code
FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xco.application_id = xld.application_id
AND xco.amb_context_code = xld.amb_context_code
AND xco.event_class_code = xld.event_class_code
AND xco.accounting_line_type_code = xld.accounting_line_type_code
AND xco.accounting_line_code = xld.accounting_line_code
AND xco.source_type_code = 'D'
UNION
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xco.application_id = xld.application_id
AND xco.amb_context_code = xld.amb_context_code
AND xco.event_class_code = xld.event_class_code
AND xco.accounting_line_type_code = xld.accounting_line_type_code
AND xco.accounting_line_code = xld.accounting_line_code
AND xco.value_source_type_code = 'D';
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code,
xco.source_type_code, xco.source_code
,xco.accounting_attribute_code
FROM xla_jlt_acct_attrs xco, xla_line_defn_jlt_assgns xld,
xla_acct_attributes_b xaab
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xco.application_id = xld.application_id
AND xco.amb_context_code = xld.amb_context_code
AND xco.event_class_code = xld.event_class_code
AND xco.accounting_line_type_code = xld.accounting_line_type_code
AND xco.accounting_line_code = xld.accounting_line_code
AND xco.source_type_code in ('S','D')
AND xaab.accounting_attribute_code = xco.accounting_attribute_code
AND xaab.assignment_level_code <> 'JLT_ONLY'
AND NOT EXISTS
(SELECT 'y'
FROM xla_evt_class_acct_attrs xes
WHERE xes.source_application_id = xco.source_application_id
AND xes.source_type_code = xco.source_type_code
AND xes.source_code = xco.source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code);
SELECT distinct xld.event_class_code, xld.event_type_code,
xld.accounting_line_type_code, xld.accounting_line_code,
xco.source_type_code, xco.source_code
,xco.accounting_attribute_code
FROM xla_jlt_acct_attrs xco, xla_line_defn_jlt_assgns xld
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xco.application_id = xld.application_id
AND xco.amb_context_code = xld.amb_context_code
AND xco.event_class_code = xld.event_class_code
AND xco.accounting_line_type_code = xld.accounting_line_type_code
AND xco.accounting_line_code = xld.accounting_line_code
AND xco.source_type_code = 'D';
SELECT xld.accounting_line_type_code
,xld.accounting_line_code
,xja.accounting_attribute_code
FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b jlt, xla_jlt_acct_attrs xja
WHERE xld.application_id = xja.application_id
AND xld.amb_context_code = xja.amb_context_code
AND xld.event_class_code = xja.event_class_code
AND xld.accounting_line_type_code = xja.accounting_line_type_code
AND xld.accounting_line_code = xja.accounting_line_code
AND xld.application_id = jlt.application_id
AND xld.amb_context_code = jlt.amb_context_code
AND xld.event_class_code = jlt.event_class_code
AND xld.accounting_line_type_code = jlt.accounting_line_type_code
AND xld.accounting_line_code = jlt.accounting_line_code
AND jlt.business_method_code <> 'PRIOR_ENTRY'
AND xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code= p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xja.source_code is null
AND EXISTS (SELECT 'x'
FROM xla_acct_attributes_b xaa
WHERE xaa.accounting_attribute_code = xja.accounting_attribute_code
AND xaa.assignment_required_code = 'Y'
AND xaa.assignment_level_code IN ('EVT_CLASS_JLT','JLT_ONLY'));
SELECT xld.accounting_line_type_code
,xld.accounting_line_code
,xja.accounting_attribute_code
FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b jlt, xla_jlt_acct_attrs xja
WHERE xld.application_id = xja.application_id
AND xld.amb_context_code = xja.amb_context_code
AND xld.event_class_code = xja.event_class_code
AND xld.accounting_line_type_code = xja.accounting_line_type_code
AND xld.accounting_line_code = xja.accounting_line_code
AND xld.application_id = jlt.application_id
AND xld.amb_context_code = jlt.amb_context_code
AND xld.event_class_code = jlt.event_class_code
AND xld.accounting_line_type_code = jlt.accounting_line_type_code
AND xld.accounting_line_code = jlt.accounting_line_code
AND jlt.business_method_code = 'PRIOR_ENTRY'
AND xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code= p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xja.source_code is null
AND EXISTS (SELECT 'x'
FROM xla_acct_attributes_b xaa
WHERE xaa.accounting_attribute_code = xja.accounting_attribute_code
AND xaa.assignment_required_code = 'Y'
AND xaa.assignment_level_code IN ('EVT_CLASS_JLT','JLT_ONLY')
AND xaa.inherited_flag = 'N');
SELECT accounting_line_type_code, accounting_line_code
FROM xla_line_defn_jlt_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
SELECT business_method_code, mpa_option_code
FROM xla_acct_line_types_b
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND accounting_line_type_code = l_accounting_line_type_code
AND accounting_line_code = l_accounting_line_code;
SELECT distinct xaa.assignment_group_code
FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
WHERE xja.application_id = p_application_id
AND xja.amb_context_code = p_amb_context_code
AND xja.event_class_code = p_event_class_code
AND xja.accounting_line_type_code = l_accounting_line_type_code
AND xja.accounting_line_code = l_accounting_line_code
AND xja.accounting_attribute_code = xaa.accounting_attribute_code
AND xja.source_code IS NOT NULL
UNION
SELECT distinct xaa.assignment_group_code
FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa
WHERE xec.application_id = p_application_id
AND xec.event_class_code = p_event_class_code
AND xec.accounting_attribute_code = xaa.accounting_attribute_code
AND xaa.assignment_level_code = 'EVT_CLASS_ONLY'
AND xec.default_flag = 'Y';
SELECT distinct xaa.accounting_attribute_code
FROM xla_acct_attributes_b xaa
,xla_jlt_acct_attrs xja
WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
AND xaa.assignment_required_code = 'G'
AND xaa.accounting_attribute_code = xja.accounting_attribute_code
AND xaa.assignment_group_code = l_assignment_group_code
AND xja.application_id = p_application_id
AND xja.amb_context_code = p_amb_context_code
AND xja.event_class_code = p_event_class_code
AND xja.accounting_line_type_code = l_accounting_line_type_code
AND xja.accounting_line_code = l_accounting_line_code
AND xja.source_code IS NULL;
SELECT distinct xaa.assignment_group_code
FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
WHERE xja.application_id = p_application_id
AND xja.amb_context_code = p_amb_context_code
AND xja.event_class_code = p_event_class_code
AND xja.accounting_line_type_code = l_accounting_line_type_code
AND xja.accounting_line_code = l_accounting_line_code
AND xja.accounting_attribute_code = xaa.accounting_attribute_code
AND (xja.source_code IS NOT NULL
OR xaa.inherited_flag = 'Y')
UNION
SELECT distinct xaa.assignment_group_code
FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa
WHERE xec.application_id = p_application_id
AND xec.event_class_code = p_event_class_code
AND xec.accounting_attribute_code = xaa.accounting_attribute_code
AND xaa.assignment_level_code = 'EVT_CLASS_ONLY'
AND xec.default_flag = 'Y';
SELECT distinct xaa.accounting_attribute_code
FROM xla_acct_attributes_b xaa
,xla_jlt_acct_attrs xja
WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
AND xaa.assignment_required_code = 'G'
AND xaa.accounting_attribute_code = xja.accounting_attribute_code
AND xaa.assignment_group_code = l_assignment_group_code
AND xja.application_id = p_application_id
AND xja.amb_context_code = p_amb_context_code
AND xja.event_class_code = p_event_class_code
AND xja.accounting_line_type_code = l_accounting_line_type_code
AND xja.accounting_line_code = l_accounting_line_code
AND xja.source_code IS NULL
AND xaa.inherited_flag = 'N';
SELECT distinct xaa.accounting_attribute_code
FROM xla_acct_attributes_b xaa
,xla_jlt_acct_attrs xja
WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
AND xaa.assignment_required_code = 'G'
AND xaa.accounting_attribute_code = xja.accounting_attribute_code
AND xaa.assignment_group_code = 'BUSINESS_FLOW'
AND xja.application_id = p_application_id
AND xja.amb_context_code = p_amb_context_code
AND xja.event_class_code = p_event_class_code
AND xja.accounting_line_type_code = l_accounting_line_type_code
AND xja.accounting_line_code = l_accounting_line_code
and xja.source_code is null;
SELECT distinct xaa.accounting_attribute_code
FROM xla_acct_attributes_b xaa
,xla_jlt_acct_attrs xja
WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
AND xaa.assignment_required_code = 'G'
AND xaa.accounting_attribute_code = xja.accounting_attribute_code
AND xaa.assignment_group_code = 'MULTIPERIOD_CODE'
AND xja.application_id = p_application_id
AND xja.amb_context_code = p_amb_context_code
AND xja.event_class_code = p_event_class_code
AND xja.accounting_line_type_code = l_accounting_line_type_code
AND xja.accounting_line_code = l_accounting_line_code
and xja.source_code is null;
SELECT distinct xdb.description_type_code, xdb.description_code
FROM xla_line_defn_jlt_assgns xjl
,xla_descriptions_b xdb
WHERE xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xjl.description_type_code IS NOT NULL
AND xdb.application_id = xjl.application_id
AND xdb.amb_context_code = xjl.amb_context_code
AND xdb.description_type_code = xjl.description_type_code
AND xdb.description_code = xjl.description_code
AND xdb.enabled_flag <> 'Y';
SELECT distinct xjl.description_type_code, xjl.description_code,
xco.source_type_code source_type_code, xco.source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.description_type_code
AND xdp.description_code = xjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.source_application_id
AND xes.source_type_code = xco.source_type_code
AND xes.source_code = xco.source_code
AND xes.application_id = xjl.application_id
AND xes.event_class_code = xjl.event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xjl.description_type_code, xjl.description_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.description_type_code
AND xdp.description_code = xjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.value_source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.value_source_application_id
AND xes.source_type_code = xco.value_source_type_code
AND xes.source_code = xco.value_source_code
AND xes.application_id = xjl.application_id
AND xes.event_class_code = xjl.event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xjl.description_type_code, xjl.description_code,
xco.source_type_code source_type_code, xco.source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.description_type_code
AND xdp.description_code = xjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.source_type_code = 'D'
UNION
SELECT distinct xjl.description_type_code, xjl.description_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.description_type_code
AND xdp.description_code = xjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.value_source_type_code = 'D';
SELECT distinct xjl.description_type_code, xjl.description_code,
xdd.source_type_code, xdd.source_code
FROM xla_descript_details_b xdd
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xdd.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.description_type_code
AND xdp.description_code = xjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xdd.source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xdd.source_application_id
AND xes.source_type_code = xdd.source_type_code
AND xes.source_code = xdd.source_code
AND xes.application_id = xjl.application_id
AND xes.event_class_code = xjl.event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xjl.description_type_code, xjl.description_code,
xdd.source_type_code, xdd.source_code
FROM xla_descript_details_b xdd
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xdd.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.description_type_code
AND xdp.description_code = xjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xdd.source_type_code = 'D';
SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
FROM xla_line_defn_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
,xla_analytical_hdrs_b xah
WHERE xah.amb_context_code = xac.amb_context_code
AND xah.analytical_criterion_code = xac.analytical_criterion_code
AND xah.analytical_criterion_type_code = xac.analytical_criterion_type_code
AND xah.enabled_flag <> 'Y'
AND xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xac.analytical_criterion_type_code, xac.analytical_criterion_code
FROM xla_line_defn_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
WHERE xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'x'
FROM xla_analytical_sources xas
WHERE xas.application_id = xac.application_id
AND xas.amb_context_code = xac.amb_context_code
AND xas.event_class_code = xac.event_class_code
AND xas.analytical_criterion_code = xac.analytical_criterion_code
AND xas.analytical_criterion_type_code = xac.analytical_criterion_type_code);
SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
xas.source_code, xas.source_type_code
FROM xla_analytical_sources xas
,xla_line_defn_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
,xla_event_sources xes
WHERE xas.application_id = xac.application_id
AND xas.amb_context_code = xac.amb_context_code
AND xas.event_class_code = xac.event_class_code
AND xas.analytical_criterion_code = xac.analytical_criterion_code
AND xas.analytical_criterion_type_code = xac.analytical_criterion_type_code
AND xas.source_type_code = 'S'
AND xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND not exists (SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xas.source_application_id
AND xes.source_type_code = xas.source_type_code
AND xes.source_code = xas.source_code
AND xes.application_id = xas.application_id
AND xes.event_class_code = xas.event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
xas.source_code, xas.source_type_code
FROM xla_analytical_sources xas
,xla_line_defn_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
WHERE xas.application_id = xac.application_id
AND xas.amb_context_code = xac.amb_context_code
AND xas.event_class_code = xac.event_class_code
AND xas.analytical_criterion_code = xac.analytical_criterion_code
AND xas.analytical_criterion_type_code = xac.analytical_criterion_type_code
AND xas.source_type_code = 'D'
AND xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.value_mapping_set_code
FROM xla_seg_rule_details xsr
,xla_line_defn_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
,xla_mapping_sets_b xms
WHERE xms.mapping_set_code = xsr.value_mapping_set_code
AND xms.amb_context_code = xsr.amb_context_code
AND xms.enabled_flag <> 'Y'
AND xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_mapping_set_code IS NOT NULL
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xld.accounting_line_type_code, xld.accounting_line_code
FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b jlt
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xld.application_id = jlt.application_id
AND xld.amb_context_code = jlt.amb_context_code
AND xld.event_class_code = jlt.event_class_code
AND xld.accounting_line_type_code = jlt.accounting_line_type_code
AND xld.accounting_line_code = jlt.accounting_line_code
AND jlt.mpa_option_code = 'ACCRUAL';
SELECT count(*)
FROM xla_mpa_jlt_assgns mpa
WHERE mpa.application_id = p_application_id
AND mpa.amb_context_code = p_amb_context_code
AND mpa.event_class_code = p_event_class_code
AND mpa.event_type_code = p_event_type_code
AND mpa.line_definition_owner_code = p_line_definition_owner_code
AND mpa.line_definition_code = p_line_definition_code
AND mpa.accounting_line_type_code = l_accounting_line_type_code
AND mpa.accounting_line_code = l_accounting_line_code;
SELECT distinct mpa.event_class_code, mpa.event_type_code,
mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code
FROM xla_line_defn_jlt_assgns xld
,xla_mpa_jlt_assgns mpa
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xld.application_id = mpa.application_id
AND xld.amb_context_code = mpa.amb_context_code
AND xld.event_class_code = mpa.event_class_code
AND xld.event_type_code = mpa.event_type_code
AND xld.line_definition_owner_code = mpa.line_definition_owner_code
AND xld.line_definition_code = mpa.line_definition_code
AND xld.accounting_line_type_code = mpa.accounting_line_type_code
AND xld.accounting_line_code = mpa.accounting_line_code
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = mpa.application_id
AND xld1.amb_context_code = mpa.amb_context_code
AND xld1.event_class_code = mpa.event_class_code
AND xld1.event_type_code = mpa.event_type_code
AND xld1.line_definition_owner_code = mpa.line_definition_owner_code
AND xld1.line_definition_code = mpa.line_definition_code
AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
AND NOT EXISTS
(SELECT 'y'
FROM xla_acct_line_types_b xal
WHERE xal.application_id = mpa.application_id
AND xal.amb_context_code = mpa.amb_context_code
AND xal.event_class_code = mpa.event_class_code
AND xal.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xal.accounting_line_code = mpa.mpa_accounting_line_code
AND xal.enabled_flag = 'Y');
SELECT distinct mpa.event_class_code, mpa.event_type_code,
mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code
FROM xla_line_defn_jlt_assgns xld
, xla_acct_line_types_b xal
,xla_mpa_jlt_assgns mpa
WHERE xal.application_id = mpa.application_id
AND xal.amb_context_code = mpa.amb_context_code
AND xal.event_class_code = mpa.event_class_code
AND xal.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xal.accounting_line_code = mpa.mpa_accounting_line_code
AND xal.enabled_flag = 'Y'
AND xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xld.application_id = mpa.application_id
AND xld.amb_context_code = mpa.amb_context_code
AND xld.event_class_code = mpa.event_class_code
AND xld.event_type_code = mpa.event_type_code
AND xld.line_definition_owner_code = mpa.line_definition_owner_code
AND xld.line_definition_code = mpa.line_definition_code
AND xld.accounting_line_type_code = mpa.accounting_line_type_code
AND xld.accounting_line_code = mpa.accounting_line_code
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = mpa.application_id
AND xld1.amb_context_code = mpa.amb_context_code
AND xld1.event_class_code = mpa.event_class_code
AND xld1.event_type_code = mpa.event_type_code
AND xld1.line_definition_owner_code = mpa.line_definition_owner_code
AND xld1.line_definition_code = mpa.line_definition_code
AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
AND NOT EXISTS
(SELECT 'y'
FROM xla_lookups xlk
WHERE xlk.lookup_type = 'XLA_ACCOUNTING_CLASS'
AND xlk.lookup_code = xal.accounting_class_code);
SELECT distinct mpa.event_class_code, mpa.event_type_code,
mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
xco.source_type_code, xco.source_code
FROM xla_conditions xco
,xla_line_defn_jlt_assgns xld
,xla_mpa_jlt_assgns mpa
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xco.application_id = mpa.application_id
AND xco.amb_context_code = mpa.amb_context_code
AND xco.event_class_code = mpa.event_class_code
AND xco.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xco.accounting_line_code = mpa.mpa_accounting_line_code
AND xco.source_type_code = 'S'
AND xld.application_id = mpa.application_id
AND xld.amb_context_code = mpa.amb_context_code
AND xld.event_class_code = mpa.event_class_code
AND xld.event_type_code = mpa.event_type_code
AND xld.line_definition_owner_code = mpa.line_definition_owner_code
AND xld.line_definition_code = mpa.line_definition_code
AND xld.accounting_line_type_code = mpa.accounting_line_type_code
AND xld.accounting_line_code = mpa.accounting_line_code
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = mpa.application_id
AND xld1.amb_context_code = mpa.amb_context_code
AND xld1.event_class_code = mpa.event_class_code
AND xld1.event_type_code = mpa.event_type_code
AND xld1.line_definition_owner_code = mpa.line_definition_owner_code
AND xld1.line_definition_code = mpa.line_definition_code
AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.source_application_id
AND xes.source_type_code = xco.source_type_code
AND xes.source_code = xco.source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct mpa.event_class_code, mpa.event_type_code,
mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_line_defn_jlt_assgns xld
,xla_mpa_jlt_assgns mpa
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xco.application_id = mpa.application_id
AND xco.amb_context_code = mpa.amb_context_code
AND xco.event_class_code = mpa.event_class_code
AND xco.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xco.accounting_line_code = mpa.mpa_accounting_line_code
AND xco.value_source_type_code = 'S'
AND xld.application_id = mpa.application_id
AND xld.amb_context_code = mpa.amb_context_code
AND xld.event_class_code = mpa.event_class_code
AND xld.event_type_code = mpa.event_type_code
AND xld.line_definition_owner_code = mpa.line_definition_owner_code
AND xld.line_definition_code = mpa.line_definition_code
AND xld.accounting_line_type_code = mpa.accounting_line_type_code
AND xld.accounting_line_code = mpa.accounting_line_code
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = mpa.application_id
AND xld1.amb_context_code = mpa.amb_context_code
AND xld1.event_class_code = mpa.event_class_code
AND xld1.event_type_code = mpa.event_type_code
AND xld1.line_definition_owner_code = mpa.line_definition_owner_code
AND xld1.line_definition_code = mpa.line_definition_code
AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.value_source_application_id
AND xes.source_type_code = xco.value_source_type_code
AND xes.source_code = xco.value_source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y');
SELECT distinct mpa.event_class_code, mpa.event_type_code,
mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
xco.source_type_code, xco.source_code
FROM xla_conditions xco
,xla_line_defn_jlt_assgns xld
,xla_mpa_jlt_assgns mpa
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xco.application_id = mpa.application_id
AND xco.amb_context_code = mpa.amb_context_code
AND xco.event_class_code = mpa.event_class_code
AND xco.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xco.accounting_line_code = mpa.mpa_accounting_line_code
AND xco.source_type_code = 'D'
AND xld.application_id = mpa.application_id
AND xld.amb_context_code = mpa.amb_context_code
AND xld.event_class_code = mpa.event_class_code
AND xld.event_type_code = mpa.event_type_code
AND xld.line_definition_owner_code = mpa.line_definition_owner_code
AND xld.line_definition_code = mpa.line_definition_code
AND xld.accounting_line_type_code = mpa.accounting_line_type_code
AND xld.accounting_line_code = mpa.accounting_line_code
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = mpa.application_id
AND xld1.amb_context_code = mpa.amb_context_code
AND xld1.event_class_code = mpa.event_class_code
AND xld1.event_type_code = mpa.event_type_code
AND xld1.line_definition_owner_code = mpa.line_definition_owner_code
AND xld1.line_definition_code = mpa.line_definition_code
AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
UNION
SELECT distinct mpa.event_class_code, mpa.event_type_code,
mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_line_defn_jlt_assgns xld
,xla_mpa_jlt_assgns mpa
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xco.application_id = mpa.application_id
AND xco.amb_context_code = mpa.amb_context_code
AND xco.event_class_code = mpa.event_class_code
AND xco.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xco.accounting_line_code = mpa.mpa_accounting_line_code
AND xco.value_source_type_code = 'D'
AND xld.application_id = mpa.application_id
AND xld.amb_context_code = mpa.amb_context_code
AND xld.event_class_code = mpa.event_class_code
AND xld.event_type_code = mpa.event_type_code
AND xld.line_definition_owner_code = mpa.line_definition_owner_code
AND xld.line_definition_code = mpa.line_definition_code
AND xld.accounting_line_type_code = mpa.accounting_line_type_code
AND xld.accounting_line_code = mpa.accounting_line_code
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = mpa.application_id
AND xld1.amb_context_code = mpa.amb_context_code
AND xld1.event_class_code = mpa.event_class_code
AND xld1.event_type_code = mpa.event_type_code
AND xld1.line_definition_owner_code = mpa.line_definition_owner_code
AND xld1.line_definition_code = mpa.line_definition_code
AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xld1.accounting_line_code = mpa.mpa_accounting_line_code) ;
SELECT mpa.mpa_accounting_line_type_code
,mpa.mpa_accounting_line_code
,xja.accounting_attribute_code
FROM xla_line_defn_jlt_assgns xld
,xla_acct_line_types_b jlt
,xla_jlt_acct_attrs xja
,xla_mpa_jlt_assgns mpa
WHERE jlt.application_id = xja.application_id
AND jlt.amb_context_code = xja.amb_context_code
AND jlt.event_class_code = xja.event_class_code
AND jlt.accounting_line_type_code = xja.accounting_line_type_code
AND jlt.accounting_line_code = xja.accounting_line_code
AND mpa.application_id = jlt.application_id
AND mpa.amb_context_code = jlt.amb_context_code
AND mpa.event_class_code = jlt.event_class_code
AND mpa.mpa_accounting_line_type_code = jlt.accounting_line_type_code
AND mpa.mpa_accounting_line_code = jlt.accounting_line_code
AND jlt.business_method_code <> 'PRIOR_ENTRY'
AND xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code= p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xld.application_id = mpa.application_id
AND xld.amb_context_code = mpa.amb_context_code
AND xld.event_class_code = mpa.event_class_code
AND xld.event_type_code = mpa.event_type_code
AND xld.line_definition_owner_code = mpa.line_definition_owner_code
AND xld.line_definition_code = mpa.line_definition_code
AND xld.accounting_line_type_code = mpa.accounting_line_type_code
AND xld.accounting_line_code = mpa.accounting_line_code
AND xja.source_code is null
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = mpa.application_id
AND xld1.amb_context_code = mpa.amb_context_code
AND xld1.event_class_code = mpa.event_class_code
AND xld1.event_type_code = mpa.event_type_code
AND xld1.line_definition_owner_code = mpa.line_definition_owner_code
AND xld1.line_definition_code = mpa.line_definition_code
AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
AND EXISTS (SELECT 'x'
FROM xla_acct_attributes_b xaa
WHERE xaa.accounting_attribute_code = xja.accounting_attribute_code
AND xaa.assignment_required_code = 'Y'
AND xaa.assignment_level_code IN ('EVT_CLASS_JLT','JLT_ONLY'));
SELECT mpa.mpa_accounting_line_type_code
,mpa.mpa_accounting_line_code
,xja.accounting_attribute_code
FROM xla_line_defn_jlt_assgns xld
,xla_acct_line_types_b jlt
,xla_jlt_acct_attrs xja
,xla_mpa_jlt_assgns mpa
WHERE jlt.application_id = xja.application_id
AND jlt.amb_context_code = xja.amb_context_code
AND jlt.event_class_code = xja.event_class_code
AND jlt.accounting_line_type_code = xja.accounting_line_type_code
AND jlt.accounting_line_code = xja.accounting_line_code
AND mpa.application_id = jlt.application_id
AND mpa.amb_context_code = jlt.amb_context_code
AND mpa.event_class_code = jlt.event_class_code
AND mpa.mpa_accounting_line_type_code = jlt.accounting_line_type_code
AND mpa.mpa_accounting_line_code = jlt.accounting_line_code
AND jlt.business_method_code = 'PRIOR_ENTRY'
AND xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code= p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xld.application_id = mpa.application_id
AND xld.amb_context_code = mpa.amb_context_code
AND xld.event_class_code = mpa.event_class_code
AND xld.event_type_code = mpa.event_type_code
AND xld.line_definition_owner_code = mpa.line_definition_owner_code
AND xld.line_definition_code = mpa.line_definition_code
AND xld.accounting_line_type_code = mpa.accounting_line_type_code
AND xld.accounting_line_code = mpa.accounting_line_code
AND xja.source_code is null
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = mpa.application_id
AND xld1.amb_context_code = mpa.amb_context_code
AND xld1.event_class_code = mpa.event_class_code
AND xld1.event_type_code = mpa.event_type_code
AND xld1.line_definition_owner_code = mpa.line_definition_owner_code
AND xld1.line_definition_code = mpa.line_definition_code
AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
AND EXISTS (SELECT 'x'
FROM xla_acct_attributes_b xaa
WHERE xaa.accounting_attribute_code = xja.accounting_attribute_code
AND xaa.assignment_required_code = 'Y'
AND xaa.assignment_level_code IN ('EVT_CLASS_JLT','JLT_ONLY')
AND xaa.inherited_flag = 'N');
SELECT distinct mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code
FROM xla_line_defn_jlt_assgns xld
,xla_mpa_jlt_assgns mpa
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.active_flag = 'Y'
AND xld.application_id = mpa.application_id
AND xld.amb_context_code = mpa.amb_context_code
AND xld.event_class_code = mpa.event_class_code
AND xld.event_type_code = mpa.event_type_code
AND xld.line_definition_owner_code = mpa.line_definition_owner_code
AND xld.line_definition_code = mpa.line_definition_code
AND xld.accounting_line_type_code = mpa.accounting_line_type_code
AND xld.accounting_line_code = mpa.accounting_line_code
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = mpa.application_id
AND xld1.amb_context_code = mpa.amb_context_code
AND xld1.event_class_code = mpa.event_class_code
AND xld1.event_type_code = mpa.event_type_code
AND xld1.line_definition_owner_code = mpa.line_definition_owner_code
AND xld1.line_definition_code = mpa.line_definition_code
AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
AND xld1.accounting_line_code = mpa.mpa_accounting_line_code) ;
SELECT business_method_code
FROM xla_acct_line_types_b
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND accounting_line_type_code = l_accounting_line_type_code
AND accounting_line_code = l_accounting_line_code;
SELECT distinct xaa.assignment_group_code
FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
WHERE xja.application_id = p_application_id
AND xja.amb_context_code = p_amb_context_code
AND xja.event_class_code = p_event_class_code
AND xja.accounting_line_type_code = l_accounting_line_type_code
AND xja.accounting_line_code = l_accounting_line_code
AND xja.accounting_attribute_code = xaa.accounting_attribute_code
AND xja.source_code IS NOT NULL
UNION
SELECT distinct xaa.assignment_group_code
FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa
WHERE xec.application_id = p_application_id
AND xec.event_class_code = p_event_class_code
AND xec.accounting_attribute_code = xaa.accounting_attribute_code
AND xaa.assignment_level_code = 'EVT_CLASS_ONLY'
AND xec.default_flag = 'Y';
SELECT distinct xaa.accounting_attribute_code
FROM xla_acct_attributes_b xaa
,xla_jlt_acct_attrs xja
WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
AND xaa.assignment_required_code = 'G'
AND xaa.accounting_attribute_code = xja.accounting_attribute_code
AND xaa.assignment_group_code = l_assignment_group_code
AND xja.application_id = p_application_id
AND xja.amb_context_code = p_amb_context_code
AND xja.event_class_code = p_event_class_code
AND xja.accounting_line_type_code = l_accounting_line_type_code
AND xja.accounting_line_code = l_accounting_line_code
AND xja.source_code IS NULL;
SELECT distinct xaa.assignment_group_code
FROM xla_jlt_acct_attrs xja, xla_acct_attributes_b xaa
WHERE xja.application_id = p_application_id
AND xja.amb_context_code = p_amb_context_code
AND xja.event_class_code = p_event_class_code
AND xja.accounting_line_type_code = l_accounting_line_type_code
AND xja.accounting_line_code = l_accounting_line_code
AND xja.accounting_attribute_code = xaa.accounting_attribute_code
AND (xja.source_code IS NOT NULL
OR xaa.inherited_flag = 'Y')
UNION
SELECT distinct xaa.assignment_group_code
FROM xla_evt_class_acct_attrs xec, xla_acct_attributes_b xaa
WHERE xec.application_id = p_application_id
AND xec.event_class_code = p_event_class_code
AND xec.accounting_attribute_code = xaa.accounting_attribute_code
AND xaa.assignment_level_code = 'EVT_CLASS_ONLY'
AND xec.default_flag = 'Y';
SELECT distinct xaa.accounting_attribute_code
FROM xla_acct_attributes_b xaa
,xla_jlt_acct_attrs xja
WHERE xaa.assignment_level_code = 'EVT_CLASS_JLT'
AND xaa.assignment_required_code = 'G'
AND xaa.accounting_attribute_code = xja.accounting_attribute_code
AND xaa.assignment_group_code = l_assignment_group_code
AND xja.application_id = p_application_id
AND xja.amb_context_code = p_amb_context_code
AND xja.event_class_code = p_event_class_code
AND xja.accounting_line_type_code = l_accounting_line_type_code
AND xja.accounting_line_code = l_accounting_line_code
AND xja.source_code IS NULL
AND xaa.inherited_flag = 'N';
SELECT distinct xdb.description_type_code, xdb.description_code
FROM xla_mpa_jlt_assgns mjl
,xla_line_defn_jlt_assgns xjl
,xla_descriptions_b xdb
WHERE xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xjl.application_id = mjl.application_id
AND xjl.amb_context_code = mjl.amb_context_code
AND xjl.event_class_code = mjl.event_class_code
AND xjl.event_type_code = mjl.event_type_code
AND xjl.line_definition_owner_code = mjl.line_definition_owner_code
AND xjl.line_definition_code = mjl.line_definition_code
AND xjl.accounting_line_type_code = mjl.accounting_line_type_code
AND xjl.accounting_line_code = mjl.accounting_line_code
AND mjl.description_type_code IS NOT NULL
AND xdb.application_id = mjl.application_id
AND xdb.amb_context_code = mjl.amb_context_code
AND xdb.description_type_code = mjl.description_type_code
AND xdb.description_code = mjl.description_code
AND xdb.enabled_flag <> 'Y';
SELECT distinct xjl.description_type_code, xjl.description_code,
xco.source_type_code source_type_code, xco.source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_mpa_jlt_assgns mjl
,xla_line_defn_jlt_assgns xjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = mjl.application_id
AND xdp.amb_context_code = mjl.amb_context_code
AND xdp.description_type_code = mjl.description_type_code
AND xdp.description_code = mjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xjl.application_id = mjl.application_id
AND xjl.amb_context_code = mjl.amb_context_code
AND xjl.event_class_code = mjl.event_class_code
AND xjl.event_type_code = mjl.event_type_code
AND xjl.line_definition_owner_code = mjl.line_definition_owner_code
AND xjl.line_definition_code = mjl.line_definition_code
AND xjl.accounting_line_type_code = mjl.accounting_line_type_code
AND xjl.accounting_line_code = mjl.accounting_line_code
AND mjl.description_code IS NOT NULL
AND xco.source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.source_application_id
AND xes.source_type_code = xco.source_type_code
AND xes.source_code = xco.source_code
AND xes.application_id = mjl.application_id
AND xes.event_class_code = mjl.event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xjl.description_type_code, xjl.description_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_assgns mjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = mjl.application_id
AND xdp.amb_context_code = mjl.amb_context_code
AND xdp.description_type_code = mjl.description_type_code
AND xdp.description_code = mjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.value_source_type_code = 'S'
AND xjl.application_id = mjl.application_id
AND xjl.amb_context_code = mjl.amb_context_code
AND xjl.event_class_code = mjl.event_class_code
AND xjl.event_type_code = mjl.event_type_code
AND xjl.line_definition_owner_code = mjl.line_definition_owner_code
AND xjl.line_definition_code = mjl.line_definition_code
AND xjl.accounting_line_type_code = mjl.accounting_line_type_code
AND xjl.accounting_line_code = mjl.accounting_line_code
AND mjl.description_code IS NOT NULL
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.value_source_application_id
AND xes.source_type_code = xco.value_source_type_code
AND xes.source_code = xco.value_source_code
AND xes.application_id = mjl.application_id
AND xes.event_class_code = mjl.event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xjl.description_type_code, xjl.description_code,
xco.source_type_code source_type_code, xco.source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_assgns mjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = mjl.application_id
AND xdp.amb_context_code = mjl.amb_context_code
AND xdp.description_type_code = mjl.description_type_code
AND xdp.description_code = mjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.source_type_code = 'D'
AND xjl.application_id = mjl.application_id
AND xjl.amb_context_code = mjl.amb_context_code
AND xjl.event_class_code = mjl.event_class_code
AND xjl.event_type_code = mjl.event_type_code
AND xjl.line_definition_owner_code = mjl.line_definition_owner_code
AND xjl.line_definition_code = mjl.line_definition_code
AND xjl.accounting_line_type_code = mjl.accounting_line_type_code
AND xjl.accounting_line_code = mjl.accounting_line_code
AND mjl.description_code IS NOT NULL
UNION
SELECT distinct xjl.description_type_code, xjl.description_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_assgns mjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = mjl.application_id
AND xdp.amb_context_code = mjl.amb_context_code
AND xdp.description_type_code = mjl.description_type_code
AND xdp.description_code = mjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.value_source_type_code = 'D'
AND xjl.application_id = mjl.application_id
AND xjl.amb_context_code = mjl.amb_context_code
AND xjl.event_class_code = mjl.event_class_code
AND xjl.event_type_code = mjl.event_type_code
AND xjl.line_definition_owner_code = mjl.line_definition_owner_code
AND xjl.line_definition_code = mjl.line_definition_code
AND xjl.accounting_line_type_code = mjl.accounting_line_type_code
AND xjl.accounting_line_code = mjl.accounting_line_code
AND mjl.description_code IS NOT NULL;
SELECT distinct xjl.description_type_code, xjl.description_code,
xdd.source_type_code, xdd.source_code
FROM xla_descript_details_b xdd
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_assgns mjl
WHERE xdd.description_prio_id = xdp.description_prio_id
AND xdp.application_id = mjl.application_id
AND xdp.amb_context_code = mjl.amb_context_code
AND xdp.description_type_code = mjl.description_type_code
AND xdp.description_code = mjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xdd.source_type_code = 'S'
AND xjl.application_id = mjl.application_id
AND xjl.amb_context_code = mjl.amb_context_code
AND xjl.event_class_code = mjl.event_class_code
AND xjl.event_type_code = mjl.event_type_code
AND xjl.line_definition_owner_code = mjl.line_definition_owner_code
AND xjl.line_definition_code = mjl.line_definition_code
AND xjl.accounting_line_type_code = mjl.accounting_line_type_code
AND xjl.accounting_line_code = mjl.accounting_line_code
AND mjl.description_code IS NOT NULL
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xdd.source_application_id
AND xes.source_type_code = xdd.source_type_code
AND xes.source_code = xdd.source_code
AND xes.application_id = mjl.application_id
AND xes.event_class_code = mjl.event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xjl.description_type_code, xjl.description_code,
xdd.source_type_code, xdd.source_code
FROM xla_descript_details_b xdd
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_assgns mjl
WHERE xdd.description_prio_id = xdp.description_prio_id
AND xdp.application_id = mjl.application_id
AND xdp.amb_context_code = mjl.amb_context_code
AND xdp.description_type_code = mjl.description_type_code
AND xdp.description_code = mjl.description_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xdd.source_type_code = 'D'
AND xjl.application_id = mjl.application_id
AND xjl.amb_context_code = mjl.amb_context_code
AND xjl.event_class_code = mjl.event_class_code
AND xjl.event_type_code = mjl.event_type_code
AND xjl.line_definition_owner_code = mjl.line_definition_owner_code
AND xjl.line_definition_code = mjl.line_definition_code
AND xjl.accounting_line_type_code = mjl.accounting_line_type_code
AND xjl.accounting_line_code = mjl.accounting_line_code
AND mjl.description_code IS NOT NULL;
SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
FROM xla_mpa_jlt_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
,xla_analytical_hdrs_b xah
WHERE xah.amb_context_code = xac.amb_context_code
AND xah.analytical_criterion_code = xac.analytical_criterion_code
AND xah.analytical_criterion_type_code = xac.analytical_criterion_type_code
AND xah.enabled_flag <> 'Y'
AND xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xac.analytical_criterion_type_code, xac.analytical_criterion_code
FROM xla_mpa_jlt_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
WHERE xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'x'
FROM xla_analytical_sources xas
WHERE xas.application_id = xac.application_id
AND xas.amb_context_code = xac.amb_context_code
AND xas.event_class_code = xac.event_class_code
AND xas.analytical_criterion_code = xac.analytical_criterion_code
AND xas.analytical_criterion_type_code = xac.analytical_criterion_type_code);
SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
xas.source_code, xas.source_type_code
FROM xla_analytical_sources xas
,xla_mpa_jlt_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
,xla_event_sources xes
WHERE xas.application_id = xac.application_id
AND xas.amb_context_code = xac.amb_context_code
AND xas.event_class_code = xac.event_class_code
AND xas.analytical_criterion_code = xac.analytical_criterion_code
AND xas.analytical_criterion_type_code = xac.analytical_criterion_type_code
AND xas.source_type_code = 'S'
AND xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND not exists (SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xas.source_application_id
AND xes.source_type_code = xas.source_type_code
AND xes.source_code = xas.source_code
AND xes.application_id = xas.application_id
AND xes.event_class_code = xas.event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
xas.source_code, xas.source_type_code
FROM xla_analytical_sources xas
,xla_mpa_jlt_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
WHERE xas.application_id = xac.application_id
AND xas.amb_context_code = xac.amb_context_code
AND xas.event_class_code = xac.event_class_code
AND xas.analytical_criterion_code = xac.analytical_criterion_code
AND xas.analytical_criterion_type_code = xac.analytical_criterion_type_code
AND xas.source_type_code = 'D'
AND xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT xld.accounting_coa_id
FROM xla_line_definitions_b xld
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code;
SELECT distinct mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code
FROM xla_line_defn_jlt_assgns xlj
,xla_acct_line_types_b jlt
,xla_acct_line_types_b jlt1
,xla_mpa_jlt_assgns mpa
WHERE xlj.application_id = p_application_id
AND xlj.amb_context_code = p_amb_context_code
AND xlj.event_class_code = p_event_class_code
AND xlj.event_type_code = p_event_type_code
AND xlj.line_definition_owner_code = p_line_definition_owner_code
AND xlj.line_definition_code = p_line_definition_code
AND xlj.active_flag = 'Y'
AND xlj.application_id = mpa.application_id
AND xlj.amb_context_code = mpa.amb_context_code
AND xlj.event_class_code = mpa.event_class_code
AND xlj.event_type_code = mpa.event_type_code
AND xlj.line_definition_owner_code = mpa.line_definition_owner_code
AND xlj.line_definition_code = mpa.line_definition_code
AND xlj.accounting_line_type_code = mpa.accounting_line_type_code
AND xlj.accounting_line_code = mpa.accounting_line_code
AND xlj.application_id = jlt1.application_id
AND xlj.amb_context_code = jlt1.amb_context_code
AND xlj.event_class_code = jlt1.event_class_code
AND xlj.accounting_line_type_code = jlt1.accounting_line_type_code
AND xlj.accounting_line_code = jlt1.accounting_line_code
AND jlt1.mpa_option_code = 'ACCRUAL'
AND mpa.application_id = jlt.application_id
AND mpa.amb_context_code = jlt.amb_context_code
AND mpa.event_class_code = jlt.event_class_code
AND mpa.mpa_accounting_line_type_code = jlt.accounting_line_type_code
AND mpa.mpa_accounting_line_code = jlt.accounting_line_code
AND jlt.business_method_code <> 'PRIOR_ENTRY'
AND NOT EXISTS
(SELECT 'x'
FROM xla_mpa_jlt_adr_assgns xad
WHERE mpa.application_id = xad.application_id
AND mpa.amb_context_code = xad.amb_context_code
AND mpa.event_class_code = xad.event_class_code
AND mpa.event_type_code = xad.event_type_code
AND mpa.line_definition_owner_code = xad.line_definition_owner_code
AND mpa.line_definition_code = xad.line_definition_code
AND mpa.accounting_line_type_code = xad.accounting_line_type_code
AND mpa.accounting_line_code = xad.accounting_line_code
AND mpa.mpa_accounting_line_type_code = xad.mpa_accounting_line_type_code
AND mpa.mpa_accounting_line_code = xad.mpa_accounting_line_code
AND xad.flexfield_segment_code = 'ALL');
SELECT distinct mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code
FROM xla_line_defn_jlt_assgns xlj
,fnd_id_flex_segments_vl fif
, xla_acct_line_types_b jlt
,xla_acct_line_types_b jlt1
,xla_mpa_jlt_assgns mpa
WHERE fif.application_id = 101
AND fif.id_flex_code = 'GL#'
AND fif.id_flex_num = l_coa_id
AND fif.enabled_flag = 'Y'
AND xlj.application_id = p_application_id
AND xlj.amb_context_code = p_amb_context_code
AND xlj.event_class_code = p_event_class_code
AND xlj.event_type_code = p_event_type_code
AND xlj.line_definition_owner_code = p_line_definition_owner_code
AND xlj.line_definition_code = p_line_definition_code
AND xlj.active_flag = 'Y'
AND xlj.application_id = jlt1.application_id
AND xlj.amb_context_code = jlt1.amb_context_code
AND xlj.event_class_code = jlt1.event_class_code
AND xlj.accounting_line_type_code = jlt1.accounting_line_type_code
AND xlj.accounting_line_code = jlt1.accounting_line_code
AND jlt1.mpa_option_code = 'ACCRUAL'
AND xlj.application_id = mpa.application_id
AND xlj.amb_context_code = mpa.amb_context_code
AND xlj.event_class_code = mpa.event_class_code
AND xlj.event_type_code = mpa.event_type_code
AND xlj.line_definition_owner_code = mpa.line_definition_owner_code
AND xlj.line_definition_code = mpa.line_definition_code
AND xlj.accounting_line_type_code = mpa.accounting_line_type_code
AND xlj.accounting_line_code = mpa.accounting_line_code
AND mpa.application_id = jlt.application_id
AND mpa.amb_context_code = jlt.amb_context_code
AND mpa.event_class_code = jlt.event_class_code
AND mpa.mpa_accounting_line_type_code = jlt.accounting_line_type_code
AND mpa.mpa_accounting_line_code = jlt.accounting_line_code
AND jlt.business_method_code <> 'PRIOR_ENTRY'
AND NOT EXISTS
(SELECT 'Y'
FROM xla_mpa_jlt_adr_assgns xad
WHERE mpa.application_id = xad.application_id
AND mpa.amb_context_code = xad.amb_context_code
AND mpa.event_class_code = xad.event_class_code
AND mpa.event_type_code = xad.event_type_code
AND mpa.line_definition_owner_code = xad.line_definition_owner_code
AND mpa.line_definition_code = xad.line_definition_code
AND mpa.accounting_line_type_code = xad.accounting_line_type_code
AND mpa.accounting_line_code = xad.accounting_line_code
AND mpa.mpa_accounting_line_type_code = xad.mpa_accounting_line_type_code
AND mpa.mpa_accounting_line_code = xad.mpa_accounting_line_code
AND xad.flexfield_segment_code = fif.application_column_name
)
AND NOT EXISTS
(SELECT 'Y'
FROM xla_mpa_jlt_adr_assgns xad
WHERE mpa.application_id = xad.application_id
AND mpa.amb_context_code = xad.amb_context_code
AND mpa.event_class_code = xad.event_class_code
AND mpa.event_type_code = xad.event_type_code
AND mpa.line_definition_owner_code = xad.line_definition_owner_code
AND mpa.line_definition_code = xad.line_definition_code
AND mpa.accounting_line_type_code = xad.accounting_line_type_code
AND mpa.accounting_line_code = xad.accounting_line_code
AND mpa.mpa_accounting_line_type_code = xad.mpa_accounting_line_type_code
AND mpa.mpa_accounting_line_code = xad.mpa_accounting_line_code
AND xad.flexfield_segment_code = 'ALL');
SELECT distinct xsr.segment_rule_type_code, xsr.segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_adr_assgns xad
,xla_seg_rules_b xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.enabled_flag <> 'Y'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code) ;
SELECT distinct xsr.application_id, xsr.amb_context_code,
xsr.segment_rule_type_code, xsr.segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_adr_assgns xad
,xla_seg_rules_b xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code) ;
SELECT xsd.value_segment_rule_type_code, xsd.value_segment_rule_code
FROM xla_seg_rule_details xsd
,xla_seg_rules_b xsr
WHERE xsd.application_id = l_adr.application_id
AND xsd.amb_context_code = l_adr.amb_context_code
AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code
AND xsd.segment_rule_code = l_adr.segment_rule_code
AND xsd.value_type_code = 'A'
AND xsd.value_segment_rule_appl_id = xsr.application_id
AND xsd.value_segment_rule_type_code = xsr.segment_rule_type_code
AND xsd.value_segment_rule_code = xsr.segment_rule_code
AND xsd.amb_context_code = xsr.amb_context_code
AND xsr.enabled_flag <> 'Y';
SELECT distinct xad.segment_rule_code, xad.segment_rule_type_code
FROM xla_mpa_jlt_adr_assgns xad, xla_line_defn_jlt_assgns xjl
WHERE xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xad.segment_rule_code is not null
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
AND NOT EXISTS
(SELECT 'x'
FROM xla_seg_rule_details xsr
WHERE xsr.application_id = NVL(xad.segment_rule_appl_id,xad.application_id)
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code);
SELECT distinct xsr.application_id, xsr.amb_context_code,
xsr.segment_rule_type_code, xsr.segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_adr_assgns xad
,xla_seg_rules_b xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code) ;
SELECT xsd.value_segment_rule_type_code, xsd.value_segment_rule_code
FROM xla_seg_rule_details xsd
WHERE xsd.application_id = l_adr.application_id
AND xsd.amb_context_code = l_adr.amb_context_code
AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code
AND xsd.segment_rule_code = l_adr.segment_rule_code
AND xsd.value_type_code = 'A'
AND not exists (SELECT 'x'
FROM xla_seg_rule_details xcd
WHERE xcd.application_id = xsd.value_segment_rule_appl_id
AND xcd.amb_context_code = xsd.amb_context_code
AND xcd.segment_rule_type_code = xsd.value_segment_rule_type_code
AND xcd.segment_rule_code = xsd.value_segment_rule_code);
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.source_type_code, xco.source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
,xla_mpa_jlt_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xco.source_type_code = 'S'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.source_application_id
AND xes.source_type_code = xco.source_type_code
AND xes.source_code = xco.source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
,xla_mpa_jlt_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xco.value_source_type_code = 'S'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.value_source_application_id
AND xes.source_type_code = xco.value_source_type_code
AND xes.source_code = xco.value_source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.source_type_code source_type_code, xco.source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
,xla_mpa_jlt_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xco.source_type_code = 'D'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
,xla_mpa_jlt_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xco.value_source_type_code = 'D'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code);
SELECT distinct xsr.value_segment_rule_appl_id,
xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_adr_assgns xad
,xla_seg_rule_details xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_type_code = 'A'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code);
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.source_type_code, xco.source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xco.source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.source_application_id
AND xes.source_type_code = xco.source_type_code
AND xes.source_code = xco.source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xco.value_source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.value_source_application_id
AND xes.source_type_code = xco.value_source_type_code
AND xes.source_code = xco.value_source_code
AND xes.application_id = p_application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.source_type_code source_type_code, xco.source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xco.source_type_code = 'D'
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_seg_rule_details xsr
WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xco.value_source_type_code = 'D';
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
FROM xla_seg_rule_details xsr
,xla_mpa_jlt_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_source_type_code = 'S'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xsr.value_source_application_id
AND xes.source_type_code = xsr.value_source_type_code
AND xes.source_code = xsr.value_source_code
AND xes.application_id = xsr.application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
FROM xla_seg_rule_details xsr
,xla_mpa_jlt_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.input_source_type_code = 'S'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xsr.input_source_application_id
AND xes.source_type_code = xsr.input_source_type_code
AND xes.source_code = xsr.input_source_code
AND xes.application_id = xsr.application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
FROM xla_seg_rule_details xsr
,xla_mpa_jlt_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_source_type_code = 'D'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
FROM xla_seg_rule_details xsr
,xla_mpa_jlt_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.input_source_type_code = 'D'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code);
SELECT distinct xsr.value_segment_rule_appl_id,
xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_adr_assgns xad
,xla_seg_rule_details xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_type_code = 'A'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code);
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
FROM xla_seg_rule_details xsr
WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xsr.value_source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xsr.value_source_application_id
AND xes.source_type_code = xsr.value_source_type_code
AND xes.source_code = xsr.value_source_code
AND xes.application_id = xsr.application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
FROM xla_seg_rule_details xsr
WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xsr.input_source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xsr.input_source_application_id
AND xes.source_type_code = xsr.input_source_type_code
AND xes.source_code = xsr.input_source_code
AND xes.application_id = xsr.application_id
AND xes.event_class_code = p_event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
FROM xla_seg_rule_details xsr
WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xsr.value_source_type_code = 'D'
UNION
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
FROM xla_seg_rule_details xsr
WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
AND xsr.amb_context_code = p_amb_context_code
AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
AND xsr.input_source_type_code = 'D';
SELECT distinct xad.segment_rule_appl_id, xad.segment_rule_type_code,
xad.segment_rule_code,
xsr.value_segment_rule_appl_id,
xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_mpa_jlt_adr_assgns xad
,xla_seg_rule_details xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_type_code = 'A'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code);
SELECT 'x'
FROM xla_seg_rule_details xsd
WHERE application_id = l_child_adr.value_segment_rule_appl_id
AND amb_context_code = p_amb_context_code
AND segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND segment_rule_code = l_child_adr.value_segment_rule_code
AND value_type_code = 'A';
SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
xsr.value_mapping_set_code
FROM xla_seg_rule_details xsr
,xla_mpa_jlt_adr_assgns xad
,xla_line_defn_jlt_assgns xjl
,xla_mapping_sets_b xms
WHERE xms.mapping_set_code = xsr.value_mapping_set_code
AND xms.amb_context_code = xsr.amb_context_code
AND xms.enabled_flag <> 'Y'
AND xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_mapping_set_code IS NOT NULL
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld1
WHERE xld1.application_id = xad.application_id
AND xld1.amb_context_code = xad.amb_context_code
AND xld1.event_class_code = xad.event_class_code
AND xld1.event_type_code = xad.event_type_code
AND xld1.line_definition_owner_code = xad.line_definition_owner_code
AND xld1.line_definition_code = xad.line_definition_code
AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
AND xld1.accounting_line_code = xad.mpa_accounting_line_code);
SELECT distinct xdb.description_type_code, xdb.description_code
FROM xla_line_defn_jlt_assgns xjl
,xla_descriptions_b xdb
WHERE xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xjl.mpa_header_desc_type_code IS NOT NULL
AND xdb.application_id = xjl.application_id
AND xdb.amb_context_code = xjl.amb_context_code
AND xdb.description_type_code = xjl.mpa_header_desc_type_code
AND xdb.description_code = xjl.mpa_header_desc_code
AND xdb.enabled_flag <> 'Y';
SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
xdd.source_type_code, xdd.source_code
FROM xla_descript_details_b xdd
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xdd.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.mpa_header_desc_type_code
AND xdp.description_code = xjl.mpa_header_desc_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xdd.source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xdd.source_application_id
AND xes.source_type_code = xdd.source_type_code
AND xes.source_code = xdd.source_code
AND xes.application_id = xjl.application_id
AND xes.event_class_code = xjl.event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
xdd.source_type_code, xdd.source_code
FROM xla_descript_details_b xdd
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xdd.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.mpa_header_desc_type_code
AND xdp.description_code = xjl.mpa_header_desc_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xdd.source_type_code = 'D';
SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
xco.source_type_code source_type_code, xco.source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.mpa_header_desc_type_code
AND xdp.description_code = xjl.mpa_header_desc_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.source_application_id
AND xes.source_type_code = xco.source_type_code
AND xes.source_code = xco.source_code
AND xes.application_id = xjl.application_id
AND xes.event_class_code = xjl.event_class_code
AND xes.active_flag = 'Y')
UNION
SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.mpa_header_desc_type_code
AND xdp.description_code = xjl.mpa_header_desc_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.value_source_type_code = 'S'
AND NOT EXISTS
(SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xco.value_source_application_id
AND xes.source_type_code = xco.value_source_type_code
AND xes.source_code = xco.value_source_code
AND xes.application_id = xjl.application_id
AND xes.event_class_code = xjl.event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
xco.source_type_code source_type_code, xco.source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.mpa_header_desc_type_code
AND xdp.description_code = xjl.mpa_header_desc_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.source_type_code = 'D'
UNION
SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
xco.value_source_type_code source_type_code, xco.value_source_code source_code
FROM xla_conditions xco
,xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
WHERE xco.description_prio_id = xdp.description_prio_id
AND xdp.application_id = xjl.application_id
AND xdp.amb_context_code = xjl.amb_context_code
AND xdp.description_type_code = xjl.mpa_header_desc_type_code
AND xdp.description_code = xjl.mpa_header_desc_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND xco.value_source_type_code = 'D';
SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
FROM xla_mpa_header_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
,xla_analytical_hdrs_b xah
WHERE xah.amb_context_code = xac.amb_context_code
AND xah.analytical_criterion_code = xac.analytical_criterion_code
AND xah.analytical_criterion_type_code = xac.analytical_criterion_type_code
AND xah.enabled_flag <> 'Y'
AND xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
FROM xla_mpa_header_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
,xla_analytical_hdrs_b xah
WHERE xah.amb_context_code = xac.amb_context_code
AND xah.analytical_criterion_code = xac.analytical_criterion_code
AND xah.analytical_criterion_type_code = xac.analytical_criterion_type_code
AND xah.balancing_flag = 'Y'
AND xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT distinct xac.analytical_criterion_type_code, xac.analytical_criterion_code
FROM xla_mpa_header_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
WHERE xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND NOT EXISTS
(SELECT 'x'
FROM xla_analytical_sources xas
WHERE xas.application_id = xac.application_id
AND xas.amb_context_code = xac.amb_context_code
AND xas.event_class_code = xac.event_class_code
AND xas.analytical_criterion_code = xac.analytical_criterion_code
AND xas.analytical_criterion_type_code = xac.analytical_criterion_type_code);
SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
xas.source_code, xas.source_type_code
FROM xla_analytical_sources xas
,xla_mpa_header_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
,xla_event_sources xes
WHERE xas.application_id = xac.application_id
AND xas.amb_context_code = xac.amb_context_code
AND xas.event_class_code = xac.event_class_code
AND xas.analytical_criterion_code = xac.analytical_criterion_code
AND xas.analytical_criterion_type_code = xac.analytical_criterion_type_code
AND xas.source_type_code = 'S'
AND xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y'
AND not exists (SELECT 'y'
FROM xla_event_sources xes
WHERE xes.source_application_id = xas.source_application_id
AND xes.source_type_code = xas.source_type_code
AND xes.source_code = xas.source_code
AND xes.application_id = xas.application_id
AND xes.event_class_code = xas.event_class_code
AND xes.active_flag = 'Y');
SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
xas.source_code, xas.source_type_code
FROM xla_analytical_sources xas
,xla_mpa_header_ac_assgns xac
,xla_line_defn_jlt_assgns xjl
WHERE xas.application_id = xac.application_id
AND xas.amb_context_code = xac.amb_context_code
AND xas.event_class_code = xac.event_class_code
AND xas.analytical_criterion_code = xac.analytical_criterion_code
AND xas.analytical_criterion_type_code = xac.analytical_criterion_type_code
AND xas.source_type_code = 'D'
AND xac.application_id = xjl.application_id
AND xac.amb_context_code = xjl.amb_context_code
AND xac.event_class_code = xjl.event_class_code
AND xac.event_type_code = xjl.event_type_code
AND xac.line_definition_code = xjl.line_definition_code
AND xac.line_definition_owner_code = xjl.line_definition_owner_code
AND xac.accounting_line_type_code = xjl.accounting_line_type_code
AND xac.accounting_line_code = xjl.accounting_line_code
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
PROCEDURE delete_line_defn_details
(p_application_id IN NUMBER
,p_amb_context_code IN VARCHAR2
,p_event_class_code IN VARCHAR2
,p_event_type_code IN VARCHAR2
,p_line_definition_owner_code IN VARCHAR2
,p_line_definition_code IN VARCHAR2)
IS
l_log_module VARCHAR2(240);
l_log_module := C_DEFAULT_MODULE||'.delete_line_defn_details';
trace(p_msg => 'BEGIN of procedure delete_line_defn_details'
,p_module => l_log_module
,p_level => C_LEVEL_PROCEDURE);
DELETE
FROM xla_line_defn_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
DELETE
FROM xla_line_defn_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
DELETE
FROM xla_line_defn_jlt_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
DELETE
FROM xla_mpa_header_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
DELETE
FROM xla_mpa_jlt_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
DELETE
FROM xla_mpa_jlt_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
DELETE
FROM xla_mpa_jlt_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
trace(p_msg => 'END of procedure delete_line_defn_details'
,p_module => l_log_module
,p_level => C_LEVEL_PROCEDURE);
(p_location => 'xla_line_definitions_pvt.delete_line_defn_details');
END delete_line_defn_details;
PROCEDURE delete_line_defn_jlt_details
(p_application_id IN NUMBER
,p_amb_context_code IN VARCHAR2
,p_event_class_code IN VARCHAR2
,p_event_type_code IN VARCHAR2
,p_line_definition_owner_code IN VARCHAR2
,p_line_definition_code IN VARCHAR2
,p_accounting_line_type_code IN VARCHAR2
,p_accounting_line_code IN VARCHAR2)
IS
l_log_module VARCHAR2(240);
l_log_module := C_DEFAULT_MODULE||'.delete_line_defn_jlt_details';
trace(p_msg => 'BEGIN of procedure delete_line_defn_jlt_details'
,p_module => l_log_module
,p_level => C_LEVEL_PROCEDURE);
DELETE
FROM xla_line_defn_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_accounting_line_type_code
AND accounting_line_code = p_accounting_line_code;
DELETE
FROM xla_line_defn_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_accounting_line_type_code
AND accounting_line_code = p_accounting_line_code;
DELETE
FROM xla_mpa_header_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_accounting_line_type_code
AND accounting_line_code = p_accounting_line_code;
DELETE
FROM xla_mpa_jlt_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_accounting_line_type_code
AND accounting_line_code = p_accounting_line_code;
DELETE
FROM xla_mpa_jlt_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_accounting_line_type_code
AND accounting_line_code = p_accounting_line_code;
DELETE
FROM xla_mpa_jlt_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_accounting_line_type_code
AND accounting_line_code = p_accounting_line_code;
trace(p_msg => 'END of procedure delete_line_defn_jlt_details'
,p_module => l_log_module
,p_level => C_LEVEL_PROCEDURE);
(p_location => 'xla_line_definitions_pvt.delete_line_defn_jlt_details');
END delete_line_defn_jlt_details;
l_last_update_date DATE := sysdate;
l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
INSERT INTO xla_line_defn_jlt_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,description_type_code
,description_code
,active_flag
,object_version_number
,inherit_desc_flag
,mpa_header_desc_code
,mpa_header_desc_type_code
,mpa_num_je_code
,mpa_gl_dates_code
,mpa_proration_code
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,description_type_code
,description_code
,active_flag
,1
,inherit_desc_flag
,mpa_header_desc_code
,mpa_header_desc_type_code
,mpa_num_je_code
,mpa_gl_dates_code
,mpa_proration_code
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_line_defn_jlt_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code;
INSERT INTO xla_mpa_header_ac_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,object_version_number
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,1
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_mpa_header_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code;
INSERT INTO xla_mpa_jlt_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,description_type_code
,description_code
,object_version_number
,inherit_desc_flag
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,description_type_code
,description_code
,1
,inherit_desc_flag
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_mpa_jlt_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code;
INSERT INTO xla_line_defn_adr_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,flexfield_segment_code
,adr_version_num
,segment_rule_appl_id
,segment_rule_type_code
,segment_rule_code
,side_code
,object_version_number
,inherit_adr_flag
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,flexfield_segment_code
,adr_version_num
,segment_rule_appl_id
,segment_rule_type_code
,segment_rule_code
,side_code
,1
,inherit_adr_flag
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_line_defn_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code
AND flexfield_segment_code = 'ALL'
UNION
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,xla_flex_pkg.get_qualifier_segment
(101
,'GL#'
,p_new_accounting_coa_id
,flexfield_segment_code)
,adr_version_num
,segment_rule_appl_id
,segment_rule_type_code
,segment_rule_code
,side_code
,1
,inherit_adr_flag
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_line_defn_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code
AND flexfield_segment_code <> 'ALL';
INSERT INTO xla_mpa_jlt_adr_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,flexfield_segment_code
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,object_version_number
,inherit_adr_flag
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,flexfield_segment_code
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,1
,inherit_adr_flag
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_mpa_jlt_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code
AND flexfield_segment_code = 'ALL'
UNION
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,xla_flex_pkg.get_qualifier_segment
(101
,'GL#'
,p_new_accounting_coa_id
,flexfield_segment_code)
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,1
,inherit_adr_flag
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_mpa_jlt_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code
AND flexfield_segment_code <> 'ALL';
INSERT INTO xla_line_defn_adr_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,flexfield_segment_code
,adr_version_num
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,side_code
,object_version_number
,inherit_adr_flag
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,flexfield_segment_code
,adr_version_num
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,side_code
,1
,inherit_adr_flag
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_line_defn_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code;
INSERT INTO xla_mpa_jlt_adr_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,flexfield_segment_code
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,object_version_number
,inherit_adr_flag
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,flexfield_segment_code
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,1
,inherit_adr_flag
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_mpa_jlt_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code;
INSERT INTO xla_line_defn_ac_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,object_version_number
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,1
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_line_defn_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code;
INSERT INTO xla_mpa_jlt_ac_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,mpa_inherit_ac_flag
,object_version_number
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,p_new_line_defn_owner_code
,p_new_line_defn_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,mpa_inherit_ac_flag
,1
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_mpa_jlt_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_old_line_defn_owner_code
AND line_definition_code = p_old_line_defn_code;
SELECT xpr.name product_rule_name
,xlk.meaning product_rule_owner
FROM xla_aad_line_defn_assgns xal
,xla_product_rules_tl xpr
,xla_lookups xlk
WHERE xpr.application_id = xal.application_id
AND xpr.amb_context_code = xal.amb_context_code
AND xpr.product_rule_type_code = xal.product_rule_type_code
AND xpr.product_rule_code = xal.product_rule_code
AND xpr.language = USERENV('LANG')
AND xlk.lookup_type = 'XLA_OWNER_TYPE'
AND xlk.lookup_code = xal.product_rule_type_code
AND xal.application_id = p_application_id
AND xal.amb_context_code = p_amb_context_code
AND xal.event_class_code = p_event_class_code
AND xal.event_type_code = p_event_type_code
AND xal.line_definition_owner_code = p_line_definition_owner_code
AND xal.line_definition_code = p_line_definition_code;
SELECT xpa.entity_code, xpa.product_rule_type_code, xpa.product_rule_code
,xpa.locking_status_flag
FROM xla_aad_line_defn_assgns xal
,xla_prod_acct_headers xpa
WHERE xpa.application_id = xal.application_id
AND xpa.amb_context_code = xal.amb_context_code
AND xpa.product_rule_type_code = xal.product_rule_type_code
AND xpa.product_rule_code = xal.product_rule_code
AND xpa.event_class_code = xal.event_class_code
AND xpa.event_type_code = xal.event_type_code
AND xpa.locking_status_flag = 'Y'
AND xal.application_id = p_application_id
AND xal.amb_context_code = p_amb_context_code
AND xal.event_class_code = p_event_class_code
AND xal.event_type_code = p_event_type_code
AND xal.line_definition_owner_code = p_line_definition_owner_code
AND xal.line_definition_code = p_line_definition_code;
SELECT xpa.entity_code, xpa.product_rule_type_code, xpa.product_rule_code
,xpa.locking_status_flag
FROM xla_aad_line_defn_assgns xal
,xla_prod_acct_headers xpa
WHERE xpa.application_id = xal.application_id
AND xpa.amb_context_code = xal.amb_context_code
AND xpa.product_rule_type_code = xal.product_rule_type_code
AND xpa.product_rule_code = xal.product_rule_code
AND xpa.event_class_code = xal.event_class_code
AND xpa.event_type_code = xal.event_type_code
AND xpa.locking_status_flag = 'Y'
AND xal.application_id = p_application_id
AND xal.amb_context_code = p_amb_context_code
AND xal.event_class_code = p_event_class_code
AND xal.event_type_code = p_event_type_code
AND xal.line_definition_owner_code = p_line_definition_owner_code
AND xal.line_definition_code = p_line_definition_code;
SELECT value_segment_rule_appl_id
,value_segment_rule_type_code
,value_segment_rule_code
FROM xla_seg_rule_details
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND segment_rule_type_code = p_segment_rule_type_code
AND segment_rule_code = p_segment_rule_code
AND value_type_code = 'A';
SELECT xpa.entity_code
,xpa.event_class_code
,xpa.event_type_code
,xpa.product_rule_type_code
,xpa.product_rule_code
,xpa.locking_status_flag
,xpa.validation_status_code
FROM xla_aad_line_defn_assgns xal
,xla_prod_acct_headers xpa
WHERE xpa.application_id = xal.application_id
AND xpa.amb_context_code = xal.amb_context_code
AND xpa.product_rule_type_code = xal.product_rule_type_code
AND xpa.product_rule_code = xal.product_rule_code
AND xpa.event_class_code = xal.event_class_code
AND xpa.event_type_code = xal.event_type_code
AND xal.application_id = p_application_id
AND xal.amb_context_code = p_amb_context_code
AND xal.event_class_code = p_event_class_code
AND xal.event_type_code = p_event_type_code
AND xal.line_definition_owner_code = p_line_definition_owner_code
AND xal.line_definition_code = p_line_definition_code
FOR UPDATE NOWAIT;
CURSOR c_update_aads IS
SELECT xal.event_class_code
, xal.product_rule_type_code
, xal.product_rule_code
FROM xla_aad_line_defn_assgns xal
,xla_prod_acct_headers xpa
WHERE xpa.application_id = xal.application_id
AND xpa.amb_context_code = xal.amb_context_code
AND xpa.product_rule_type_code = xal.product_rule_type_code
AND xpa.product_rule_code = xal.product_rule_code
AND xpa.event_class_code = xal.event_class_code
AND xpa.event_type_code = xal.event_type_code
AND xal.application_id = p_application_id
AND xal.amb_context_code = p_amb_context_code
AND xal.event_class_code = p_event_class_code
AND xal.event_type_code = p_event_type_code
AND xal.line_definition_owner_code = p_line_definition_owner_code
AND xal.line_definition_code = p_line_definition_code
FOR UPDATE NOWAIT;
OPEN c_update_aads;
FETCH c_update_aads BULK COLLECT INTO l_event_class_codes
,l_product_rule_type_codes
,l_product_rule_codes;
CLOSE c_update_aads;
UPDATE xla_product_rules_b xpr
SET compile_status_code = 'N'
, updated_flag = 'Y'
, last_update_date = sysdate
, last_updated_by = xla_environment_pkg.g_usr_id
, last_update_login = xla_environment_pkg.g_login_id
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND product_rule_type_code = l_product_rule_type_codes(i)
AND product_rule_code = l_product_rule_codes(i)
AND (compile_status_code <> 'N' OR
updated_flag <> 'Y');
trace(p_msg => '# row updated in xla_product_rules_b = '||SQL%ROWCOUNT,
p_module => l_log_module,
p_level => C_LEVEL_EVENT);
UPDATE xla_prod_acct_headers xpa
SET validation_status_code = 'N'
, last_update_date = sysdate
, last_updated_by = xla_environment_pkg.g_usr_id
, last_update_login = xla_environment_pkg.g_login_id
WHERE xpa.application_id = p_application_id
AND xpa.amb_context_code = p_amb_context_code
AND xpa.event_class_code = l_event_class_codes(i)
AND xpa.product_rule_type_code = l_product_rule_type_codes(i)
AND xpa.product_rule_code = l_product_rule_codes(i)
AND xpa.validation_status_code <> 'N';
trace(p_msg => '# row updated in xla_prod_acct_headers = '||SQL%ROWCOUNT,
p_module => l_log_module,
p_level => C_LEVEL_EVENT);
UPDATE xla_appli_amb_contexts
SET updated_flag = 'Y'
, last_update_date = sysdate
, last_updated_by = xla_environment_pkg.g_usr_id
, last_update_login = xla_environment_pkg.g_login_id
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND updated_flag <> 'Y';
UPDATE xla_line_definitions_b
SET validation_status_code = 'N'
,last_update_date = sysdate
,last_updated_by = xla_environment_pkg.g_usr_id
,last_update_login = xla_environment_pkg.g_login_id
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
IF c_update_aads%ISOPEN THEN
CLOSE c_update_aads;
IF c_update_aads%ISOPEN THEN
CLOSE c_update_aads;
l_last_update_date DATE := sysdate;
l_last_update_login INTEGER := xla_environment_pkg.g_login_id;
l_last_updated_by INTEGER := xla_environment_pkg.g_usr_id;
INSERT INTO xla_line_defn_adr_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,flexfield_segment_code
,adr_version_num
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,side_code
,object_version_number
,inherit_adr_flag
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,p_new_accting_line_type_code
,p_new_accounting_line_code
,flexfield_segment_code
,adr_version_num
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,side_code
,1
,inherit_adr_flag
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_line_defn_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_old_accting_line_type_code
AND accounting_line_code = p_old_accounting_line_code;
INSERT INTO xla_mpa_jlt_adr_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,flexfield_segment_code
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,object_version_number
,inherit_adr_flag
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,p_new_accting_line_type_code
,p_new_accounting_line_code
,p_new_accting_line_type_code
,p_new_accounting_line_code
,flexfield_segment_code
,segment_rule_type_code
,segment_rule_code
,segment_rule_appl_id
,1
,inherit_adr_flag
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_mpa_jlt_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_old_accting_line_type_code
AND accounting_line_code = p_old_accounting_line_code
AND mpa_accounting_line_type_code = p_old_accting_line_type_code
AND mpa_accounting_line_code = p_old_accounting_line_code;
INSERT INTO xla_line_defn_ac_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,object_version_number
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,p_new_accting_line_type_code
,p_new_accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,1
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_line_defn_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_old_accting_line_type_code
AND accounting_line_code = p_old_accounting_line_code;
INSERT INTO xla_mpa_header_ac_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,object_version_number
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,p_new_accting_line_type_code
,p_new_accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,1
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_mpa_header_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_old_accting_line_type_code
AND accounting_line_code = p_old_accounting_line_code;
INSERT INTO xla_mpa_jlt_ac_assgns
(application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,accounting_line_type_code
,accounting_line_code
,mpa_accounting_line_type_code
,mpa_accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,mpa_inherit_ac_flag
,object_version_number
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login)
SELECT
application_id
,amb_context_code
,event_class_code
,event_type_code
,line_definition_owner_code
,line_definition_code
,p_new_accting_line_type_code
,p_new_accounting_line_code
,p_new_accting_line_type_code
,p_new_accounting_line_code
,analytical_criterion_type_code
,analytical_criterion_code
,mpa_inherit_ac_flag
,1
,l_creation_date
,l_created_by
,l_last_update_date
,l_last_updated_by
,l_last_update_login
FROM xla_mpa_jlt_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_old_accting_line_type_code
AND accounting_line_code = p_old_accounting_line_code
AND mpa_accounting_line_type_code = p_old_accting_line_type_code
AND mpa_accounting_line_code = p_old_accounting_line_code;
SELECT xld.name, xlk.meaning owner
FROM xla_line_definitions_tl xld
,xla_lookups xlk
WHERE xld.application_id = p_application_id
AND xld.amb_context_code = p_amb_context_code
AND xld.event_class_code = p_event_class_code
AND xld.event_type_code = p_event_type_code
AND xld.line_definition_owner_code = p_line_definition_owner_code
AND xld.line_definition_code = p_line_definition_code
AND xld.language = USERENV('LANG')
AND xlk.lookup_type = 'XLA_OWNER_TYPE'
AND xlk.lookup_code = xld.line_definition_owner_code;
DELETE FROM xla_amb_setup_errors
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code;
xla_amb_setup_err_pkg.insert_errors;
SELECT laa.flexfield_segment_code, seg.flex_value_set_id
FROM xla_line_defn_adr_assgns laa, xla_seg_rules_b seg
WHERE laa.application_id = p_application_id
AND laa.amb_context_code = p_amb_context_code
AND laa.event_class_code = p_event_class_code
AND laa.event_type_code = p_event_type_code
AND laa.line_definition_owner_code = p_old_line_defn_owner_code
AND laa.line_definition_code = p_old_line_defn_code
AND laa.flexfield_segment_code <> 'ALL'
AND laa.segment_rule_appl_id = seg.application_id
AND laa.amb_context_code = seg.amb_context_code
AND laa.segment_rule_code = seg.segment_rule_code
AND laa.segment_rule_type_code = seg.segment_rule_type_code;
SELECT 'x'
FROM fnd_id_flex_segments
WHERE application_id = 101
AND id_flex_code = 'GL#'
AND id_flex_num = p_new_accounting_coa_id
AND application_column_name = l_flexfield_segment_code
AND flex_value_set_id = l_adr.flex_value_set_id
;
SELECT distinct xsr.value_segment_rule_appl_id,
xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
FROM xla_line_defn_jlt_assgns xjl
,xla_line_defn_adr_assgns xad
,xla_seg_rule_details xsr
WHERE xsr.application_id = xad.application_id
AND xsr.amb_context_code = xad.amb_context_code
AND xsr.segment_rule_type_code = xad.segment_rule_type_code
AND xsr.segment_rule_code = xad.segment_rule_code
AND xsr.value_type_code = 'A'
AND xad.application_id = xjl.application_id
AND xad.amb_context_code = xjl.amb_context_code
AND xad.line_definition_owner_code = xjl.line_definition_owner_code
AND xad.line_definition_code = xjl.line_definition_code
AND xad.event_class_code = xjl.event_class_code
AND xad.event_type_code = xjl.event_type_code
AND xad.accounting_line_type_code = xjl.accounting_line_type_code
AND xad.accounting_line_code = xjl.accounting_line_code
AND xad.segment_rule_code is not null
AND xjl.application_id = p_application_id
AND xjl.amb_context_code = p_amb_context_code
AND xjl.event_class_code = p_event_class_code
AND xjl.event_type_code = p_event_type_code
AND xjl.line_definition_owner_code = p_line_definition_owner_code
AND xjl.line_definition_code = p_line_definition_code
AND xjl.active_flag = 'Y';
SELECT 'x'
FROM xla_seg_rule_details xsd
WHERE application_id = l_child_adr.value_segment_rule_appl_id
AND amb_context_code = p_amb_context_code
AND segment_rule_type_code = l_child_adr.value_segment_rule_type_code
AND segment_rule_code = l_child_adr.value_segment_rule_code
AND value_type_code = 'A';
PROCEDURE delete_mpa_jlt_details
(p_application_id IN NUMBER
,p_amb_context_code IN VARCHAR2
,p_event_class_code IN VARCHAR2
,p_event_type_code IN VARCHAR2
,p_line_definition_owner_code IN VARCHAR2
,p_line_definition_code IN VARCHAR2
,p_accounting_line_type_code IN VARCHAR2
,p_accounting_line_code IN VARCHAR2
,p_mpa_accounting_line_type_co IN VARCHAR2
,p_mpa_accounting_line_code IN VARCHAR2)
IS
l_log_module VARCHAR2(240);
l_log_module := C_DEFAULT_MODULE||'.delete_mpa_jlt_details';
trace(p_msg => 'BEGIN of procedure delete_mpa_jlt_details'
,p_module => l_log_module
,p_level => C_LEVEL_PROCEDURE);
DELETE
FROM xla_mpa_jlt_adr_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_accounting_line_type_code
AND accounting_line_code = p_accounting_line_code
AND mpa_accounting_line_type_code = p_mpa_accounting_line_type_co
AND mpa_accounting_line_code = p_mpa_accounting_line_code;
DELETE
FROM xla_mpa_jlt_ac_assgns
WHERE application_id = p_application_id
AND amb_context_code = p_amb_context_code
AND event_class_code = p_event_class_code
AND event_type_code = p_event_type_code
AND line_definition_owner_code = p_line_definition_owner_code
AND line_definition_code = p_line_definition_code
AND accounting_line_type_code = p_accounting_line_type_code
AND accounting_line_code = p_accounting_line_code
AND mpa_accounting_line_type_code = p_mpa_accounting_line_type_co
AND mpa_accounting_line_code = p_mpa_accounting_line_code;
trace(p_msg => 'END of procedure delete_mpa_jlt_details'
,p_module => l_log_module
,p_level => C_LEVEL_PROCEDURE);
(p_location => 'xla_line_definitions_pvt.delete_mpa_jlt_details');
END delete_mpa_jlt_details;