APPS.GR_TOXIC_EFFECTS_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 := EffectDesc.last_update_login;
428: CLOSE c_get_descriptions;
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 841: FROM fnd_languages lng

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

Line 940: FROM fnd_languages lng

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

Line 1183: from GR_TOXIC_EFFECTS_TL B, FND_LANGUAGES L

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