The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
FROM xla_seg_rules_b a
WHERE exists (SELECT 'x'
FROM xla_seg_rule_details sd
WHERE ((value_source_application_id = p_der_application_id
AND value_source_type_code = p_der_source_type_code
AND value_source_code = p_der_source_code)
OR (input_source_application_id = p_der_application_id
AND input_source_type_code = p_der_source_type_code
AND input_source_code = p_der_source_code
AND input_source_code IS NOT NULL))
AND sd.application_id = a.application_id
AND sd.amb_context_code = a.amb_context_code
AND sd.segment_rule_type_code = a.segment_rule_type_code
AND sd.segment_rule_code = a.segment_rule_code
UNION
SELECT 'x'
FROM xla_conditions c, xla_seg_rule_details sd
WHERE ((c.source_application_id = p_der_application_id
AND c.source_code = p_der_source_code
AND c.source_type_code = p_der_source_type_code)
OR (c.value_source_application_id = p_der_application_id
AND c.value_source_type_code = p_der_source_type_code
AND c.value_source_code = p_der_source_code
AND c.value_source_code IS NOT NULL))
AND c.segment_rule_detail_id = sd.segment_rule_detail_id
AND sd.application_id = a.application_id
AND sd.amb_context_code = a.amb_context_code
AND sd.segment_rule_type_code = a.segment_rule_type_code
AND sd.segment_rule_code = a.segment_rule_code);
SELECT 'x'
FROM xla_conditions c
WHERE ((source_application_id = p_der_application_id
AND source_code = p_der_source_code
AND source_type_code = p_der_source_type_code)
OR (value_source_application_id = p_der_application_id
AND value_source_type_code = p_der_source_type_code
AND value_source_code = p_der_source_code
AND value_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_seg_rule_details sd,
xla_tab_acct_def_details pl, xla_tab_acct_defs_b p
WHERE sd.segment_rule_detail_id = c.segment_rule_detail_id
AND pl.application_id = sd.application_id
AND pl.amb_context_code = sd.amb_context_code
AND pl.segment_rule_type_code = sd.segment_rule_type_code
AND pl.segment_rule_code = sd.segment_rule_code
AND pl.application_id = p.application_id
AND pl.amb_context_code = p.amb_context_code
AND pl.account_definition_type_code = p.account_definition_type_code
AND pl.account_definition_code = p.account_definition_code
AND p.locking_status_flag = 'Y');
SELECT 'x'
FROM xla_seg_rule_details sd
WHERE ((value_source_application_id = p_der_application_id
AND value_source_type_code = p_der_source_type_code
AND value_source_code = p_der_source_code)
OR (input_source_application_id = p_der_application_id
AND input_source_type_code = p_der_source_type_code
AND input_source_code = p_der_source_code
AND input_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_tab_acct_def_details pl, xla_tab_acct_defs_b p
WHERE pl.application_id = sd.application_id
AND pl.amb_context_code = sd.amb_context_code
AND pl.segment_rule_type_code = sd.segment_rule_type_code
AND pl.segment_rule_code = sd.segment_rule_code
AND pl.application_id = p.application_id
AND pl.amb_context_code = p.amb_context_code
AND pl.account_definition_type_code = p.account_definition_type_code
AND pl.account_definition_code = p.account_definition_code
AND p.locking_status_flag = 'Y');
SELECT amb_context_code, analytical_criterion_code, analytical_criterion_type_code
FROM xla_analytical_hdrs_b a
WHERE exists (SELECT 'x'
FROM xla_analytical_sources r
WHERE source_application_id = p_der_application_id
AND source_code = p_der_source_code
AND source_type_code = p_der_source_type_code
AND r.analytical_criterion_code = a.analytical_criterion_code
AND r.analytical_criterion_type_code = a.analytical_criterion_type_code);
SELECT x.application_id, x.amb_context_code,
x.description_type_code, x.description_code
FROM xla_descriptions_b x
WHERE exists (SELECT 'x'
FROM xla_descript_details_b d, xla_desc_priorities dp
WHERE d.source_application_id = p_der_application_id
AND d.source_code = p_der_source_code
AND d.source_type_code = p_der_source_type_code
AND d.source_code is not null
AND dp.description_prio_id = d.description_prio_id
AND dp.application_id = x.application_id
AND dp.amb_context_code = x.amb_context_code
AND dp.description_type_code = x.description_type_code
AND dp.description_code = x.description_code
UNION
SELECT 'x'
FROM xla_conditions c, xla_desc_priorities dp
WHERE ((c.source_application_id = p_der_application_id
AND c.source_code = p_der_source_code
AND c.source_type_code = p_der_source_type_code)
OR (c.value_source_application_id = p_der_application_id
AND c.value_source_type_code = p_der_source_type_code
AND c.value_source_code = p_der_source_code
AND c.value_source_code IS NOT NULL))
AND dp.description_prio_id = c.description_prio_id
AND dp.application_id = x.application_id
AND dp.amb_context_code = x.amb_context_code
AND dp.description_type_code = x.description_type_code
AND dp.description_code = x.description_code);
SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
FROM xla_seg_rules_b a
WHERE exists (SELECT 'x'
FROM xla_seg_rule_details sd
WHERE ((value_source_application_id = p_der_application_id
AND value_source_type_code = p_der_source_type_code
AND value_source_code = p_der_source_code)
OR (input_source_application_id = p_der_application_id
AND input_source_type_code = p_der_source_type_code
AND input_source_code = p_der_source_code
AND input_source_code IS NOT NULL))
AND sd.application_id = a.application_id
AND sd.amb_context_code = a.amb_context_code
AND sd.segment_rule_type_code = a.segment_rule_type_code
AND sd.segment_rule_code = a.segment_rule_code
UNION
SELECT 'x'
FROM xla_conditions c, xla_seg_rule_details sd
WHERE ((c.source_application_id = p_der_application_id
AND c.source_code = p_der_source_code
AND c.source_type_code = p_der_source_type_code)
OR (c.value_source_application_id = p_der_application_id
AND c.value_source_type_code = p_der_source_type_code
AND c.value_source_code = p_der_source_code
AND c.value_source_code IS NOT NULL))
AND c.segment_rule_detail_id = sd.segment_rule_detail_id
AND sd.application_id = a.application_id
AND sd.amb_context_code = a.amb_context_code
AND sd.segment_rule_type_code = a.segment_rule_type_code
AND sd.segment_rule_code = a.segment_rule_code);
SELECT a.application_id, a.amb_context_code, a.entity_code, a.event_class_code,
a.accounting_line_type_code, a.accounting_line_code
FROM xla_acct_line_types_b a
,xla_conditions c
WHERE a.application_id = c.application_id
AND a.amb_context_code = c.amb_context_code
AND a.entity_code = c.entity_code
AND a.event_class_code = c.event_class_code
AND a.accounting_line_type_code = c.accounting_line_type_code
AND a.accounting_line_code = c.accounting_line_code
AND ((c.source_application_id = p_der_application_id
AND c.source_code = p_der_source_code
AND c.source_type_code = p_der_source_type_code)
OR (c.value_source_application_id = p_der_application_id
AND c.value_source_type_code = p_der_source_type_code
AND c.value_source_code = p_der_source_code
AND c.value_source_code IS NOT NULL))
UNION
SELECT a.application_id, a.amb_context_code, a.entity_code, a.event_class_code,
a.accounting_line_type_code, a.accounting_line_code
FROM xla_acct_line_types_b a
,xla_jlt_acct_attrs r
WHERE a.application_id = r.application_id
AND a.amb_context_code = r.amb_context_code
AND a.event_class_code = r.event_class_code
AND a.accounting_line_type_code = r.accounting_line_type_code
AND a.accounting_line_code = r.accounting_line_code
AND r.source_application_id = p_der_application_id
AND r.source_code = p_der_source_code
AND r.source_type_code = p_der_source_type_code
AND r.source_code IS NOT NULL;
SELECT application_id, amb_context_code, product_rule_type_code, product_rule_code
FROM xla_product_rules_b a
WHERE exists (SELECT 'x'
FROM xla_aad_hdr_acct_attrs r
WHERE source_application_id = p_der_application_id
AND source_code = p_der_source_code
AND source_type_code = p_der_source_type_code
AND source_code is not null
AND r.application_id = a.application_id
AND r.amb_context_code = a.amb_context_code
AND r.product_rule_type_code = a.product_rule_type_code
AND r.product_rule_code = a.product_rule_code);
SELECT 'x'
FROM xla_analytical_sources xas
WHERE source_application_id = p_der_application_id
AND source_code = p_der_source_code
AND source_type_code = p_der_source_type_code
AND exists (SELECT 'x'
FROM xla_aad_header_ac_assgns xah
, xla_prod_acct_headers xpa
WHERE xah.amb_context_code = xas.amb_context_code
AND xah.analytical_criterion_code = xas.analytical_criterion_code
AND xah.analytical_criterion_type_code = xas.analytical_criterion_type_code
AND xpa.application_id = xah.application_id
AND xpa.amb_context_code = xah.amb_context_code
AND xpa.product_rule_type_code = xah.product_rule_type_code
AND xpa.product_rule_code = xah.product_rule_code
AND xpa.event_class_code = xah.event_class_code
AND xpa.event_type_code = xah.event_type_code
AND xpa.locking_status_flag = 'Y'
UNION
SELECT 'x'
FROM xla_line_defn_ac_assgns xld
, xla_aad_line_defn_assgns xal
, xla_prod_acct_headers xpa
WHERE xld.amb_context_code = xas.amb_context_code
AND xld.analytical_criterion_code = xas.analytical_criterion_code
AND xld.analytical_criterion_type_code = xas.analytical_criterion_type_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.event_type_code = xld.event_type_code
AND xal.line_definition_owner_code = xld.line_definition_owner_code
AND xal.line_definition_code = xld.line_definition_code
AND 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');
SELECT 'x'
FROM xla_descript_details_b xdd
WHERE source_application_id = p_der_application_id
AND source_code = p_der_source_code
AND source_type_code = p_der_source_type_code
AND source_code is not null
AND exists (SELECT 'x'
FROM xla_desc_priorities xdp
, xla_line_defn_jlt_assgns xld
, xla_aad_line_defn_assgns xal
, xla_prod_acct_headers xpa
WHERE xdp.description_prio_id = xdd.description_prio_id
AND xld.application_id = xdp.application_id
AND xld.amb_context_code = xdp.amb_context_code
AND xld.description_type_code = xdp.description_type_code
AND xld.description_code = xdp.description_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.event_type_code = xld.event_type_code
AND xal.line_definition_owner_code = xld.line_definition_owner_code
AND xal.line_definition_code = xld.line_definition_code
AND 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'
UNION
SELECT 'x'
FROM xla_desc_priorities xdp
, xla_prod_acct_headers xpa
WHERE xdp.description_prio_id = xdd.description_prio_id
AND xpa.application_id = xdp.application_id
AND xpa.amb_context_code = xdp.amb_context_code
AND xpa.description_type_code = xdp.description_type_code
AND xpa.description_code = xdp.description_code
AND xpa.locking_status_flag = 'Y');
SELECT 'x'
FROM xla_conditions xco
WHERE ((source_application_id = p_der_application_id
AND source_code = p_der_source_code
AND source_type_code = p_der_source_type_code)
OR (value_source_application_id = p_der_application_id
AND value_source_type_code = p_der_source_type_code
AND value_source_code = p_der_source_code
AND value_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_desc_priorities xdp,
xla_line_defn_jlt_assgns xld,
xla_aad_line_defn_assgns xal,
xla_prod_acct_headers xpa
WHERE xdp.description_prio_id = xco.description_prio_id
AND xld.application_id = xdp.application_id
AND xld.amb_context_code = xdp.amb_context_code
AND xld.description_type_code = xdp.description_type_code
AND xld.description_code = xdp.description_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.event_type_code = xld.event_type_code
AND xal.line_definition_owner_code = xld.line_definition_owner_code
AND xal.line_definition_code = xld.line_definition_code
AND 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');
SELECT 'x'
FROM xla_conditions xco
WHERE ((source_application_id = p_der_application_id
AND source_code = p_der_source_code
AND source_type_code = p_der_source_type_code)
OR (value_source_application_id = p_der_application_id
AND value_source_type_code = p_der_source_type_code
AND value_source_code = p_der_source_code
AND value_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_seg_rule_details xsd,
xla_line_defn_adr_assgns xld,
xla_aad_line_defn_assgns xal,
xla_prod_acct_headers xpa
WHERE xsd.segment_rule_detail_id = xco.segment_rule_detail_id
AND xld.application_id = xsd.application_id
AND xld.amb_context_code = xsd.amb_context_code
AND xld.segment_rule_type_code = xsd.segment_rule_type_code
AND xld.segment_rule_code = xsd.segment_rule_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.event_type_code = xld.event_type_code
AND xal.line_definition_owner_code = xld.line_definition_owner_code
AND xal.line_definition_code = xld.line_definition_code
AND 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');
SELECT 'x'
FROM xla_conditions xco
WHERE ((source_application_id = p_der_application_id
AND source_code = p_der_source_code
AND source_type_code = p_der_source_type_code)
OR (value_source_application_id = p_der_application_id
AND value_source_type_code = p_der_source_type_code
AND value_source_code = p_der_source_code
AND value_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld,
xla_aad_line_defn_assgns xal,
xla_prod_acct_headers xpa
WHERE xld.application_id = xco.application_id
AND xld.amb_context_code = xco.amb_context_code
AND xld.event_class_code = xco.event_class_code
AND xld.accounting_line_type_code = xco.accounting_line_type_code
AND xld.accounting_line_code = xco.accounting_line_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.event_type_code = xld.event_type_code
AND xal.line_definition_owner_code = xld.line_definition_owner_code
AND xal.line_definition_code = xld.line_definition_code
AND 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');
SELECT 'x'
FROM xla_seg_rule_details xsr
WHERE ((value_source_application_id = p_der_application_id
AND value_source_type_code = p_der_source_type_code
AND value_source_code = p_der_source_code)
OR (input_source_application_id = p_der_application_id
AND input_source_type_code = p_der_source_type_code
AND input_source_code = p_der_source_code
AND input_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_line_defn_adr_assgns xld,
xla_aad_line_defn_assgns xal,
xla_prod_acct_headers xpa
WHERE xld.application_id = xsr.application_id
AND xld.amb_context_code = xsr.amb_context_code
AND xld.segment_rule_type_code = xsr.segment_rule_type_code
AND xld.segment_rule_code = xsr.segment_rule_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.event_type_code = xld.event_type_code
AND xal.line_definition_owner_code = xld.line_definition_owner_code
AND xal.line_definition_code = xld.line_definition_code
AND 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');
SELECT 'x'
FROM xla_jlt_acct_attrs xja
WHERE source_application_id = p_der_application_id
AND source_code = p_der_source_code
AND source_type_code = p_der_source_type_code
AND exists (SELECT 'x'
FROM xla_line_defn_jlt_assgns xld,
xla_aad_line_defn_assgns xal,
xla_prod_acct_headers xpa
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 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.event_type_code = xld.event_type_code
AND xal.line_definition_owner_code = xld.line_definition_owner_code
AND xal.line_definition_code = xld.line_definition_code
AND 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');
SELECT 'x'
FROM DUAL
WHERE EXISTS (SELECT 'x'
FROM xla_aad_hdr_acct_attrs xah, xla_prod_acct_headers xpa
WHERE xah.source_application_id = p_der_application_id
AND xah.source_code = p_der_source_code
AND xah.source_type_code = p_der_source_type_code
AND xah.source_type_code IS NOT NULL
AND xpa.application_id = xah.application_id
AND xpa.amb_context_code = xah.amb_context_code
AND xpa.product_rule_type_code = xah.product_rule_type_code
AND xpa.product_rule_code = xah.product_rule_code
AND xpa.event_class_code = xah.event_class_code
AND xpa.event_type_code = xah.event_type_code
AND xpa.locking_status_flag = 'Y');
SELECT 'x'
FROM xla_event_sources
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code;
SELECT 'x'
FROM xla_evt_class_acct_attrs
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code;
SELECT 'x'
FROM xla_source_params
WHERE ref_source_application_id = p_application_id
AND ref_source_code = p_source_code
AND ref_source_type_code = p_source_type_code;
SELECT 'x'
FROM xla_analytical_sources
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code;
SELECT 'x'
FROM xla_jlt_acct_attrs
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code;
SELECT 'x'
FROM xla_aad_hdr_acct_attrs
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code;
SELECT 'x'
FROM xla_descript_details_b
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code
AND source_code is not null;
SELECT 'x'
FROM DUAL
WHERE EXISTS
(SELECT 'x'
FROM xla_seg_rule_details
WHERE value_source_application_id = p_application_id
AND value_source_code = p_source_code
AND value_source_type_code = p_source_type_code
AND value_source_code is not null
UNION
SELECT 'x'
FROM xla_seg_rule_details
WHERE input_source_application_id = p_application_id
AND input_source_code = p_source_code
AND input_source_type_code = p_source_type_code
AND input_source_code is not null);
SELECT 'x'
FROM DUAL
WHERE EXISTS
(SELECT 'x'
FROM xla_conditions
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code
UNION
SELECT 'x'
FROM xla_conditions
WHERE value_source_application_id = p_application_id
AND value_source_code = p_source_code
AND value_source_type_code = p_source_type_code
AND value_source_code is not null);
SELECT 'x'
FROM xla_seg_rule_details
WHERE input_source_application_id = p_application_id
AND input_source_code = p_source_code
AND input_source_type_code = p_source_type_code
AND input_source_code is not null;
IF p_event in ('DELETE', 'DISABLE') THEN
OPEN check_entity_sources;
ELSIF p_event = 'UPDATE_DT' THEN
OPEN check_ssa_acctg_sources;
ELSIF p_event = ('UPDATE_VS') THEN
OPEN check_input_source;
IF p_event in ('DELETE', 'DISABLE', 'UPDATE_DT') THEN
OPEN check_acct_line_sources;
SELECT 'x'
FROM xla_analytical_sources xas
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code
AND exists (SELECT 'x'
FROM xla_aad_header_ac_assgns xah
, xla_prod_acct_headers xpa
WHERE xah.amb_context_code = xas.amb_context_code
AND xah.analytical_criterion_code = xas.analytical_criterion_code
AND xah.analytical_criterion_type_code = xas.analytical_criterion_type_code
AND xpa.application_id = xah.application_id
AND xpa.amb_context_code = xah.amb_context_code
AND xpa.product_rule_type_code = xah.product_rule_type_code
AND xpa.product_rule_code = xah.product_rule_code
AND xpa.event_class_code = xah.event_class_code
AND xpa.event_type_code = xah.event_type_code
AND xpa.locking_status_flag = 'Y'
UNION
SELECT 'x'
FROM xla_line_defn_ac_assgns xad
, xla_aad_line_defn_assgns xal
, xla_prod_acct_headers xpa
WHERE xad.amb_context_code = xas.amb_context_code
AND xad.analytical_criterion_code = xas.analytical_criterion_code
AND xad.analytical_criterion_type_code = xas.analytical_criterion_type_code
AND xal.application_id = xad.application_id
AND xal.amb_context_code = xad.amb_context_code
AND xal.event_class_code = xad.event_class_code
AND xal.event_type_code = xad.event_type_code
AND xal.line_definition_owner_code = xad.line_definition_owner_code
AND xal.line_definition_code = xad.line_definition_code
AND xpa.application_id = xal.application_id
AND xpa.amb_context_code = xal.amb_context_code
AND xpa.event_class_code = xal.event_class_code
AND xpa.event_type_code = xal.event_type_code
AND xpa.product_rule_type_code = xal.product_rule_type_code
AND xpa.product_rule_code = xal.product_rule_code
AND xpa.locking_status_flag = 'Y');
SELECT 'x'
FROM xla_descript_details_b xdd
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code
AND source_code is not null
AND exists (SELECT 'x'
FROM xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xjl
,xla_aad_line_defn_assgns xal
,xla_prod_acct_headers xpa
WHERE xdp.description_prio_id = xdd.description_prio_id
AND xjl.application_id = xdp.application_id
AND xjl.amb_context_code = xdp.amb_context_code
AND xjl.description_type_code = xdp.description_type_code
AND xjl.description_code = xdp.description_code
AND xal.application_id = xjl.application_id
AND xal.amb_context_code = xjl.amb_context_code
AND xal.event_class_code = xjl.event_class_code
AND xal.event_type_code = xjl.event_type_code
AND xal.line_definition_owner_code = xjl.line_definition_owner_code
AND xal.line_definition_code = xjl.line_definition_code
AND xpa.application_id = xal.application_id
AND xpa.amb_context_code = xal.amb_context_code
AND xpa.event_class_code = xal.event_class_code
AND xpa.event_type_code = xal.event_type_code
AND xpa.product_rule_type_code = xal.product_rule_type_code
AND xpa.product_rule_code = xal.product_rule_code
AND xpa.locking_status_flag = 'Y'
UNION
SELECT 'x'
FROM xla_desc_priorities xdp
, xla_prod_acct_headers xpa
WHERE xdp.description_prio_id = xdd.description_prio_id
AND xpa.application_id = xdp.application_id
AND xpa.amb_context_code = xdp.amb_context_code
AND xpa.description_type_code = xdp.description_type_code
AND xpa.description_code = xdp.description_code
AND xpa.locking_status_flag = 'Y');
SELECT 'x'
FROM xla_conditions xco
WHERE ((source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code)
OR (value_source_application_id = p_application_id
AND value_source_type_code = p_source_type_code
AND value_source_code = p_source_code
AND value_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_desc_priorities xdp
,xla_line_defn_jlt_assgns xld
,xla_aad_line_defn_assgns xal
,xla_prod_acct_headers xpa
WHERE xdp.description_prio_id = xco.description_prio_id
AND xld.application_id = xdp.application_id
AND xld.amb_context_code = xdp.amb_context_code
AND xld.description_type_code = xdp.description_type_code
AND xld.description_code = xdp.description_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.event_type_code = xld.event_type_code
AND xal.line_definition_owner_code = xld.line_definition_owner_code
AND xal.line_definition_code = xld.line_definition_code
AND xpa.application_id = xal.application_id
AND xpa.amb_context_code = xal.amb_context_code
AND xpa.event_class_code = xal.event_class_code
AND xpa.event_type_code = xal.event_type_code
AND xpa.product_rule_type_code = xal.product_rule_type_code
AND xpa.product_rule_code = xal.product_rule_code
AND xpa.locking_status_flag = 'Y');
SELECT 'x'
FROM xla_conditions xco
WHERE ((source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code)
OR (value_source_application_id = p_application_id
AND value_source_type_code = p_source_type_code
AND value_source_code = p_source_code
AND value_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_seg_rule_details xsr
,xla_line_defn_adr_assgns xld
,xla_aad_line_defn_assgns xal
,xla_prod_acct_headers xpa
WHERE xsr.segment_rule_detail_id = xco.segment_rule_detail_id
AND xld.application_id = xsr.application_id
AND xld.amb_context_code = xsr.amb_context_code
AND xld.segment_rule_type_code = xsr.segment_rule_type_code
AND xld.segment_rule_code = xsr.segment_rule_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.event_type_code = xld.event_type_code
AND xal.line_definition_owner_code = xld.line_definition_owner_code
AND xal.line_definition_code = xld.line_definition_code
AND xpa.application_id = xal.application_id
AND xpa.amb_context_code = xal.amb_context_code
AND xpa.event_class_code = xal.event_class_code
AND xpa.event_type_code = xal.event_type_code
AND xpa.product_rule_type_code = xal.product_rule_type_code
AND xpa.product_rule_code = xal.product_rule_code
AND xpa.locking_status_flag = 'Y');
SELECT 'x'
FROM xla_conditions c
WHERE ((source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code)
OR (value_source_application_id = p_application_id
AND value_source_type_code = p_source_type_code
AND value_source_code = p_source_code
AND value_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_line_defn_jlt_assgns pl
,xla_aad_line_defn_assgns p
,xla_prod_acct_headers xpa
WHERE pl.application_id = c.application_id
AND pl.amb_context_code = c.amb_context_code
AND pl.event_class_code = c.event_class_code
AND pl.accounting_line_type_code = c.accounting_line_type_code
AND pl.accounting_line_code = c.accounting_line_code
AND pl.application_id = p.application_id
AND pl.amb_context_code = p.amb_context_code
AND pl.event_class_code = p.event_class_code
AND pl.event_type_code = p.event_type_code
AND pl.line_definition_owner_code = p.line_definition_owner_code
AND pl.line_definition_code = p.line_definition_code
AND xpa.application_id = p.application_id
AND xpa.amb_context_code = p.amb_context_code
AND xpa.event_class_code = p.event_class_code
AND xpa.event_type_code = p.event_type_code
AND xpa.product_rule_type_code = p.product_rule_type_code
AND xpa.product_rule_code = p.product_rule_code
AND xpa.locking_status_flag = 'Y');
SELECT 'x'
FROM xla_seg_rule_details sd
WHERE ((value_source_application_id = p_application_id
AND value_source_type_code = p_source_type_code
AND value_source_code = p_source_code)
OR (input_source_application_id = p_application_id
AND input_source_type_code = p_source_type_code
AND input_source_code = p_source_code
AND input_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_line_defn_adr_assgns pl
,xla_aad_line_defn_assgns p
,xla_prod_acct_headers xpa
WHERE pl.application_id = sd.application_id
AND pl.amb_context_code = sd.amb_context_code
AND pl.segment_rule_type_code = sd.segment_rule_type_code
AND pl.segment_rule_code = sd.segment_rule_code
AND pl.application_id = p.application_id
AND pl.amb_context_code = p.amb_context_code
AND pl.event_class_code = p.event_class_code
AND pl.event_type_code = p.event_type_code
AND pl.line_definition_owner_code = p.line_definition_owner_code
AND pl.line_definition_code = p.line_definition_code
AND xpa.application_id = p.application_id
AND xpa.amb_context_code = p.amb_context_code
AND xpa.event_class_code = p.event_class_code
AND xpa.event_type_code = p.event_type_code
AND xpa.product_rule_type_code = p.product_rule_type_code
AND xpa.product_rule_code = p.product_rule_code
AND xpa.locking_status_flag = 'Y');
SELECT 'x'
FROM xla_jlt_acct_attrs r
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code
AND exists (SELECT 'x'
FROM xla_line_defn_jlt_assgns pl
,xla_aad_line_defn_assgns p
,xla_prod_acct_headers xpa
WHERE pl.application_id = r.application_id
AND pl.amb_context_code = r.amb_context_code
AND pl.event_class_code = r.event_class_code
AND pl.accounting_line_type_code = r.accounting_line_type_code
AND pl.accounting_line_code = r.accounting_line_code
AND pl.application_id = p.application_id
AND pl.amb_context_code = p.amb_context_code
AND pl.event_class_code = p.event_class_code
AND pl.event_type_code = p.event_type_code
AND pl.line_definition_owner_code = p.line_definition_owner_code
AND pl.line_definition_code = p.line_definition_code
AND xpa.application_id = p.application_id
AND xpa.amb_context_code = p.amb_context_code
AND xpa.event_class_code = p.event_class_code
AND xpa.event_type_code = p.event_type_code
AND xpa.product_rule_type_code = p.product_rule_type_code
AND xpa.product_rule_code = p.product_rule_code
AND xpa.locking_status_flag = 'Y');
SELECT 'x'
FROM DUAL
WHERE EXISTS (SELECT 'x'
FROM xla_aad_hdr_acct_attrs r, xla_prod_acct_headers p
WHERE r.source_application_id = p_application_id
AND r.source_code = p_source_code
AND r.source_type_code = p_source_type_code
AND r.source_type_code IS NOT NULL
AND p.application_id = r.application_id
AND p.amb_context_code = r.amb_context_code
AND p.product_rule_type_code = r.product_rule_type_code
AND p.product_rule_code = r.product_rule_code
AND p.event_class_code = r.event_class_code
AND p.event_type_code = r.event_type_code
AND p.locking_status_flag = 'Y');
SELECT application_id, source_type_code, source_code
FROM xla_sources_b r
WHERE exists (SELECT 'x'
FROM xla_source_params p
WHERE p.ref_source_application_id = p_application_id
AND p.ref_source_code = p_source_code
AND p.ref_source_type_code = p_source_type_code
AND p.application_id = r.application_id
AND p.source_type_code = r.source_type_code
AND p.source_code = r.source_code);
SELECT amb_context_code, analytical_criterion_code, analytical_criterion_type_code
FROM xla_analytical_hdrs_b a
WHERE exists (SELECT 'x'
FROM xla_analytical_sources r
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code
AND r.amb_context_code = a.amb_context_code
AND r.analytical_criterion_code = a.analytical_criterion_code
AND r.analytical_criterion_type_code = a.analytical_criterion_type_code);
SELECT x.application_id, x.amb_context_code,
x.description_type_code, x.description_code
FROM xla_descriptions_b x
WHERE exists (SELECT 'x'
FROM xla_descript_details_b d, xla_desc_priorities dp
WHERE d.source_application_id = p_application_id
AND d.source_code = p_source_code
AND d.source_type_code = p_source_type_code
AND d.source_code is not null
AND dp.description_prio_id = d.description_prio_id
AND dp.application_id = x.application_id
AND dp.amb_context_code = x.amb_context_code
AND dp.description_type_code = x.description_type_code
AND dp.description_code = x.description_code
UNION
SELECT 'x'
FROM xla_conditions c, xla_desc_priorities dp
WHERE ((c.source_application_id = p_application_id
AND c.source_code = p_source_code
AND c.source_type_code = p_source_type_code)
OR (c.value_source_application_id = p_application_id
AND c.value_source_type_code = p_source_type_code
AND c.value_source_code = p_source_code
AND c.value_source_code IS NOT NULL))
AND dp.description_prio_id = c.description_prio_id
AND dp.application_id = x.application_id
AND dp.amb_context_code = x.amb_context_code
AND dp.description_type_code = x.description_type_code
AND dp.description_code = x.description_code);
SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
FROM xla_seg_rules_b a
WHERE exists (SELECT 'x'
FROM xla_seg_rule_details sd
WHERE ((value_source_application_id = p_application_id
AND value_source_type_code = p_source_type_code
AND value_source_code = p_source_code)
OR (input_source_application_id = p_application_id
AND input_source_type_code = p_source_type_code
AND input_source_code = p_source_code
AND input_source_code IS NOT NULL))
AND sd.application_id = a.application_id
AND sd.amb_context_code = a.amb_context_code
AND sd.segment_rule_type_code = a.segment_rule_type_code
AND sd.segment_rule_code = a.segment_rule_code
UNION
SELECT 'x'
FROM xla_conditions c, xla_seg_rule_details sd
WHERE ((c.source_application_id = p_application_id
AND c.source_code = p_source_code
AND c.source_type_code = p_source_type_code)
OR (c.value_source_application_id = p_application_id
AND c.value_source_type_code = p_source_type_code
AND c.value_source_code = p_source_code
AND c.value_source_code IS NOT NULL))
AND c.segment_rule_detail_id = sd.segment_rule_detail_id
AND sd.application_id = a.application_id
AND sd.amb_context_code = a.amb_context_code
AND sd.segment_rule_type_code = a.segment_rule_type_code
AND sd.segment_rule_code = a.segment_rule_code);
SELECT application_id, a.amb_context_code, entity_code, event_class_code,
accounting_line_type_code, accounting_line_code
FROM xla_acct_line_types_b a
WHERE exists (SELECT 'x'
FROM xla_conditions c
WHERE ((source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code)
OR (value_source_application_id = p_application_id
AND value_source_type_code = p_source_type_code
AND value_source_code = p_source_code
AND value_source_code IS NOT NULL))
AND c.application_id = a.application_id
AND c.amb_context_code = a.amb_context_code
AND c.entity_code = a.entity_code
AND c.event_class_code = a.event_class_code
AND c.accounting_line_type_code = a.accounting_line_type_code
AND c.accounting_line_code = a.accounting_line_code
UNION
SELECT 'x'
FROM xla_jlt_acct_attrs r
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code
AND r.application_id = a.application_id
AND r.amb_context_code = a.amb_context_code
AND r.event_class_code = a.event_class_code
AND r.accounting_line_type_code = a.accounting_line_type_code
AND r.accounting_line_code = a.accounting_line_code);
SELECT application_id, amb_context_code,
product_rule_type_code, product_rule_code
FROM xla_product_rules_b a
WHERE exists (SELECT 'x'
FROM xla_aad_hdr_acct_attrs r
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code
AND source_code is not null
AND r.application_id = a.application_id
AND r.amb_context_code = a.amb_context_code
AND r.product_rule_type_code = a.product_rule_type_code
AND r.product_rule_code = a.product_rule_code);
SELECT application_id, source_type_code, source_code
FROM xla_sources_b r
WHERE exists (SELECT 'x'
FROM xla_source_params p
WHERE p.ref_source_application_id = p_application_id
AND p.ref_source_code = p_source_code
AND p.ref_source_type_code = p_source_type_code
AND p.application_id = r.application_id
AND p.source_type_code = r.source_type_code
AND p.source_code = r.source_code);
| delete_derived_source_details |
| |
| Deletes details of the derived source when the source is deleted |
| |
+======================================================================*/
PROCEDURE delete_derived_source_details
(p_application_id IN NUMBER
,p_source_code IN VARCHAR2
,p_source_type_code IN VARCHAR2)
IS
l_log_module VARCHAR2(240);
l_log_module := C_DEFAULT_MODULE||'.delete_derived_source_details';
trace(p_msg => 'BEGIN of procedure delete_derived_source_details'
,p_module => l_log_module
,p_level => C_LEVEL_PROCEDURE);
DELETE
FROM xla_source_params
WHERE application_id = p_application_id
AND source_type_code = p_source_type_code
AND source_code = p_source_code;
DELETE
FROM xla_event_sources
WHERE source_application_id = p_application_id
AND source_type_code = p_source_type_code
AND source_code = p_source_code;
trace(p_msg => 'END of procedure delete_derived_source_details'
,p_module => l_log_module
,p_level => C_LEVEL_PROCEDURE);
(p_location => 'xla_sources_pkg.delete_derived_source_details');
END delete_derived_source_details;
SELECT 'x'
FROM xla_source_params r
WHERE application_id = p_application_id
AND source_code = p_derived_source_code
AND source_type_code = p_derived_source_type_code
AND ref_source_code is not null
AND ref_source_type_code = 'S'
AND not exists (SELECT 'x'
FROM xla_event_sources s
WHERE s.source_application_id = r.ref_source_application_id
AND s.source_type_code = r.ref_source_type_code
AND s.source_code = r.ref_source_code
AND s.application_id = p_application_id
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y'
AND s.level_code = 'H');
SELECT 'x'
FROM xla_source_params r
WHERE application_id = p_application_id
AND source_code = p_derived_source_code
AND source_type_code = p_derived_source_type_code
AND ref_source_code is not null
AND ref_source_type_code = 'S'
AND not exists (SELECT 'x'
FROM xla_event_sources s
WHERE s.source_application_id = r.ref_source_application_id
AND s.source_type_code = r.ref_source_type_code
AND s.source_code = r.ref_source_code
AND s.application_id = p_application_id
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y');
SELECT 'x'
FROM xla_tab_acct_type_srcs
WHERE source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code;
IF p_event in ('DELETE', 'DISABLE') THEN
OPEN check_trx_acct_type;
SELECT 'x'
FROM xla_conditions c
WHERE ((source_application_id = p_application_id
AND source_code = p_source_code
AND source_type_code = p_source_type_code)
OR (value_source_application_id = p_application_id
AND value_source_type_code = p_source_type_code
AND value_source_code = p_source_code
AND value_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_seg_rule_details sd,
xla_tab_acct_def_details pl, xla_tab_acct_defs_b p
WHERE sd.segment_rule_detail_id = c.segment_rule_detail_id
AND pl.application_id = sd.application_id
AND pl.amb_context_code = sd.amb_context_code
AND pl.segment_rule_type_code = sd.segment_rule_type_code
AND pl.segment_rule_code = sd.segment_rule_code
AND pl.application_id = p.application_id
AND pl.amb_context_code = p.amb_context_code
AND pl.account_definition_type_code = p.account_definition_type_code
AND pl.account_definition_code = p.account_definition_code
AND p.locking_status_flag = 'Y');
SELECT 'x'
FROM xla_seg_rule_details sd
WHERE ((value_source_application_id = p_application_id
AND value_source_type_code = p_source_type_code
AND value_source_code = p_source_code)
OR (input_source_application_id = p_application_id
AND input_source_type_code = p_source_type_code
AND input_source_code = p_source_code
AND input_source_code IS NOT NULL))
AND exists (SELECT 'x'
FROM xla_tab_acct_def_details pl, xla_tab_acct_defs_b p
WHERE pl.application_id = sd.application_id
AND pl.amb_context_code = sd.amb_context_code
AND pl.segment_rule_type_code = sd.segment_rule_type_code
AND pl.segment_rule_code = sd.segment_rule_code
AND pl.application_id = p.application_id
AND pl.amb_context_code = p.amb_context_code
AND pl.account_definition_type_code = p.account_definition_type_code
AND pl.account_definition_code = p.account_definition_code
AND p.locking_status_flag = 'Y');
SELECT application_id, source_type_code, source_code
FROM xla_sources_b r
WHERE exists (SELECT 'x'
FROM xla_source_params p
WHERE p.ref_source_application_id = p_application_id
AND p.ref_source_code = p_source_code
AND p.ref_source_type_code = p_source_type_code
AND p.application_id = r.application_id
AND p.source_type_code = r.source_type_code
AND p.source_code = r.source_code);
SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
FROM xla_seg_rules_b a
WHERE exists (SELECT 'x'
FROM xla_seg_rule_details sd
WHERE ((value_source_application_id = p_application_id
AND value_source_type_code = p_source_type_code
AND value_source_code = p_source_code)
OR (input_source_application_id = p_application_id
AND input_source_type_code = p_source_type_code
AND input_source_code = p_source_code
AND input_source_code IS NOT NULL))
AND sd.application_id = a.application_id
AND sd.amb_context_code = a.amb_context_code
AND sd.segment_rule_type_code = a.segment_rule_type_code
AND sd.segment_rule_code = a.segment_rule_code
UNION
SELECT 'x'
FROM xla_conditions c, xla_seg_rule_details sd
WHERE ((c.source_application_id = p_application_id
AND c.source_code = p_source_code
AND c.source_type_code = p_source_type_code)
OR (c.value_source_application_id = p_application_id
AND c.value_source_type_code = p_source_type_code
AND c.value_source_code = p_source_code
AND c.value_source_code IS NOT NULL))
AND c.segment_rule_detail_id = sd.segment_rule_detail_id
AND sd.application_id = a.application_id
AND sd.amb_context_code = a.amb_context_code
AND sd.segment_rule_type_code = a.segment_rule_type_code
AND sd.segment_rule_code = a.segment_rule_code);
SELECT application_id, source_type_code, source_code
FROM xla_sources_b r
WHERE exists (SELECT 'x'
FROM xla_source_params p
WHERE p.ref_source_application_id = p_application_id
AND p.ref_source_code = p_source_code
AND p.ref_source_type_code = p_source_type_code
AND p.application_id = r.application_id
AND p.source_type_code = r.source_type_code
AND p.source_code = r.source_code);
SELECT 'x'
FROM xla_seg_rule_details s
WHERE s.value_source_application_id = p_application_id
AND s.value_source_code = p_source_code
AND s.value_source_type_code = p_source_type_code
AND s.value_source_code is not null
AND exists (SELECT 'x'
FROM xla_tab_acct_def_details d
WHERE s.application_id = d.application_id
AND d.account_type_code = p_account_type_code
AND s.amb_context_code = d.amb_context_code
AND s.segment_rule_code = d.segment_rule_code
AND s.segment_rule_type_code = d.segment_rule_type_code);
SELECT 'x'
FROM xla_seg_rule_details s
WHERE s.input_source_application_id = p_application_id
AND s.input_source_code = p_source_code
AND s.input_source_type_code = p_source_type_code
AND s.input_source_code is not null
AND exists (SELECT 'x'
FROM xla_tab_acct_def_details d
WHERE s.application_id = d.application_id
AND d.account_type_code = p_account_type_code
AND s.amb_context_code = d.amb_context_code
AND s.segment_rule_code = d.segment_rule_code
AND s.segment_rule_type_code = d.segment_rule_type_code);
SELECT 'x'
FROM xla_conditions c
WHERE c.source_application_id = p_application_id
AND c.source_code = p_source_code
AND c.source_type_code = p_source_type_code
AND exists (SELECT 'x'
FROM xla_tab_acct_def_details d, xla_seg_rule_details s
WHERE s.application_id = d.application_id
AND d.account_type_code = p_account_type_code
AND s.amb_context_code = d.amb_context_code
AND s.segment_rule_code = d.segment_rule_code
AND s.segment_rule_type_code = d.segment_rule_type_code
AND s.segment_rule_detail_id = c.segment_rule_detail_id);
SELECT 'x'
FROM xla_conditions c
WHERE value_source_application_id = p_application_id
AND value_source_code = p_source_code
AND value_source_type_code = p_source_type_code
AND value_source_code is not null
AND exists (SELECT 'x'
FROM xla_tab_acct_def_details d, xla_seg_rule_details s
WHERE s.application_id = d.application_id
AND d.account_type_code = p_account_type_code
AND s.amb_context_code = d.amb_context_code
AND s.segment_rule_code = d.segment_rule_code
AND s.segment_rule_type_code = d.segment_rule_type_code
AND s.segment_rule_detail_id = c.segment_rule_detail_id);
SELECT 'x'
FROM xla_source_params r
WHERE application_id = p_application_id
AND source_code = p_derived_source_code
AND source_type_code = p_derived_source_type_code
AND ref_source_code is not null
AND ref_source_type_code = 'S'
AND not exists (SELECT 'x'
FROM xla_event_sources s
WHERE s.source_application_id = r.ref_source_application_id
AND s.source_type_code = r.ref_source_type_code
AND s.source_code = r.ref_source_code
AND s.application_id = p_application_id
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y');
SELECT 'x'
FROM xla_source_params r
WHERE application_id = p_application_id
AND source_code = p_derived_source_code
AND source_type_code = p_derived_source_type_code
AND ref_source_code is not null
AND ref_source_type_code = 'S'
AND exists (SELECT 'x'
FROM xla_event_sources s
WHERE s.source_application_id = r.ref_source_application_id
AND s.source_type_code = r.ref_source_type_code
AND s.source_code = r.ref_source_code
AND s.application_id = p_application_id
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y'
AND s.level_code = 'C');
SELECT 'x'
FROM xla_source_params r
WHERE application_id = p_application_id
AND source_code = p_derived_source_code
AND source_type_code = p_derived_source_type_code
AND ref_source_code is not null
AND ref_source_type_code = 'S'
AND exists (SELECT 'x'
FROM xla_event_sources s
WHERE s.source_application_id = r.ref_source_application_id
AND s.source_type_code = r.ref_source_type_code
AND s.source_code = r.ref_source_code
AND s.application_id = p_application_id
AND s.event_class_code = p_event_class_code
AND s.active_flag = 'Y'
AND s.level_code = 'L');