APPS.XLA_TAB_PKG SQL Statements

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

Line: 161

      SELECT id_flex_structure_name
        INTO l_transaction_coa_name
        FROM fnd_id_flex_structures_vl ffsvl
       WHERE ffsvl.application_id = 101
         AND ffsvl.id_flex_code   = 'GL#'
         AND ffsvl.id_flex_num    = p_transaction_coa_id;

Line: 229

      SELECT compile_status_code
            ,chart_of_accounts_id
            ,name
        INTO l_compile_status_code
            ,l_tad_coa_id
            ,l_tad_name
        FROM xla_tab_acct_defs_vl xtd
       WHERE xtd.application_id               = g_application_info.application_id
         AND xtd.account_definition_code      = p_account_definition_code
         AND xtd.account_definition_type_code = p_account_definition_type_code
         AND xtd.amb_context_code             = l_amb_context_code;

Line: 413

      SELECT id_flex_structure_name
        INTO l_tad_coa_name
        FROM fnd_id_flex_structures_vl ffsvl
       WHERE ffsvl.application_id = 101
         AND ffsvl.id_flex_code   = 'GL#'
         AND ffsvl.id_flex_num    = l_tad_coa_id;