APPS.GR_TOXIC_SPECIES_TL_PKG dependencies on FND_LANGUAGES

Line 366: FROM fnd_languages lng

362:
363: CURSOR c_get_installed_languages
364: IS
365: SELECT lng.language_code
366: FROM fnd_languages lng
367: WHERE lng.installed_flag IN ('I', 'B');
368: InstLang c_get_installed_languages%ROWTYPE;
369:
370: BEGIN

Line 431: /* Read fnd_languages for the installed and base languages.

427: l_last_update_login := SpeciesDesc.last_update_login;
428: CLOSE c_get_descs;
429: END IF;
430:
431: /* Read fnd_languages for the installed and base languages.
432: ** For those that are found, read the labels tl table.
433: ** If there isn't a record in the table for that language then
434: ** insert it and go on to the next.
435: */

Line 842: FROM fnd_languages lng

838:
839: CURSOR c_get_language
840: IS
841: SELECT lng.language_code
842: FROM fnd_languages lng
843: WHERE lng.language_code = l_language_code;
844: LangRecord c_get_language%ROWTYPE;
845:
846: BEGIN

Line 941: FROM fnd_languages lng

937:
938: CURSOR c_get_language_code
939: IS
940: SELECT lng.installed_flag
941: FROM fnd_languages lng
942: WHERE lng.language_code = p_language
943: AND lng.installed_flag IN ('B', 'I');
944: LangRecord c_get_language_code%ROWTYPE;
945:

Line 1185: from GR_TOXIC_SPECIES_TL B, FND_LANGUAGES L

1181: B.LAST_UPDATE_DATE,
1182: B.LAST_UPDATE_LOGIN,
1183: L.LANGUAGE_CODE,
1184: B.SOURCE_LANG
1185: from GR_TOXIC_SPECIES_TL B, FND_LANGUAGES L
1186: where L.INSTALLED_FLAG in ('I', 'B')
1187: and B.LANGUAGE = userenv('LANG')
1188: and not exists
1189: (select NULL