APPS.FND_OBIEE_I18N SQL Statements

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

Line: 34

      select decode(fl.language_code,
          'PTB', fl.ISO_LANGUAGE||'-'||fl.ISO_TERRITORY,
          'ZHT', fl.ISO_LANGUAGE||'-'||fl.ISO_TERRITORY,
          'ZHS', fl.ISO_LANGUAGE||'-'||fl.ISO_TERRITORY,
          fl.iso_language)
      into target_lang_code
      from fnd_languages fl
      where u_lang_code = fl.language_code;

Line: 86

          select fl.language_code
          into target_lang_code
          from fnd_languages fl
          where fl.iso_language = target_lang
            and fl.iso_territory = target_terr;

Line: 101

          select fl.language_code
          into target_lang_code
          from fnd_languages fl
          where fl.iso_language = u_lang_code;

Line: 269

      select fl.language_code
      into target_lang_code
      from fnd_languages fl
      where fl.nls_language = upper(lang);

Line: 287

      select fl.nls_language
      into target_language
      from fnd_languages fl
      where fl.language_code = upper(target_lang_code);

Line: 318

  select lower(fl.ISO_LANGUAGE)||'-'||lower(ft.TERRITORY_CODE)
  into o_locale
  from fnd_languages fl, FND_TERRITORIES ft
  where fnd_global.nls_language = fl.nls_language
    and fnd_global.nls_territory = ft.nls_territory
    and ft.OBSOLETE_FLAG = 'N';

Line: 341

  select language_code
  into base_lang_code
  from fnd_languages
  where installed_flag = 'B';

Line: 358

          select installed_flag
          into install_status
          from fnd_languages
          where language_code = target_lang_code;

Line: 396

  select nls_language
  into target_language
  from fnd_languages
  where language_code = target_lang_code;