APPS.XLA_RPT_SARDLR_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 178

    SELECT name
      FROM xla_sources_vl
     WHERE application_id   = p_source_application_id
       AND source_type_code = p_source_type_code
       AND source_code      = p_source_code;

Line: 189

    SELECT name, flexfield_application_id, id_flex_code, segment_code
      FROM xla_sources_vl
     WHERE application_id   = p_source_application_id
       AND source_type_code = p_source_type_code
       AND source_code      = p_source_code;

Line: 200

    SELECT name, view_application_id, lookup_type, flex_value_set_id,
           flexfield_application_id, id_flex_code, segment_code
      FROM xla_sources_vl
     WHERE application_id   = p_source_application_id
       AND source_type_code = p_source_type_code
       AND source_code      = p_source_code;

Line: 211

    SELECT name, view_application_id, lookup_type, value_set_id
      FROM xla_mapping_sets_vl
     WHERE mapping_set_code  = p_mapping_set_code;

Line: 221

    SELECT name
      FROM xla_seg_rules_fvl
     WHERE amb_context_code       = p_amb_context_code
       AND application_id         = p_value_segment_rule_appl_id
       AND segment_rule_type_code = p_value_segment_rule_type_code
       AND segment_rule_code      = p_value_segment_rule_code;