APPS.XLA_TAB_ACCT_DEFS_PKG SQL Statements

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

Line: 50

   SELECT 'x'
     FROM xla_seg_rule_details d
    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;

Line: 59

   SELECT value_source_type_code source_type_code, value_source_code source_code
     FROM xla_seg_rule_details d
    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_source_code is not null
      AND value_source_type_code = 'S'
      AND NOT EXISTS (SELECT 'y'
                        FROM xla_tab_acct_type_srcs 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.account_type_code     = p_account_type_code)
   UNION
   SELECT input_source_type_code source_type_code, input_source_code source_code
     FROM xla_seg_rule_details d
    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 input_source_code is not null
      AND input_source_type_code = 'S'
      AND NOT EXISTS (SELECT 'y'
                        FROM xla_tab_acct_type_srcs 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.account_type_code     = p_account_type_code);

Line: 95

   SELECT c.source_type_code, c.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         = 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_tab_acct_type_srcs 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.account_type_code     = p_account_type_code)
   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         = 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_tab_acct_type_srcs 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.account_type_code     = p_account_type_code);

Line: 133

   SELECT value_source_type_code source_type_code, value_source_code source_code
     FROM xla_seg_rule_details d
    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_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         = 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';

Line: 155

   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         = 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         = 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';

Line: 454

   SELECT 'x'
     FROM xla_tab_acct_defs_b
    WHERE application_id                  = p_application_id
      AND amb_context_code                = p_amb_context_code
      AND account_definition_type_code    = p_account_definition_type_code
      AND account_definition_code         = p_account_definition_code
      AND compile_status_code       in ('E','N','Y')
      AND locking_status_flag       = 'N'
   FOR UPDATE of compile_status_code NOWAIT;

Line: 476

      UPDATE xla_tab_acct_defs_b
         SET compile_status_code = 'N'
       WHERE current of c_prod_rules;