APPS.GR_EUROHAZARDS_TL_PKG dependencies on FND_LANGUAGES

Line 363: FROM fnd_languages lng

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

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

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

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 1204: from FND_LANGUAGES L

1200: l_sysdate,
1201: 0,
1202: L.LANGUAGE_CODE,
1203: userenv('LANG')
1204: from FND_LANGUAGES L
1205: where L.INSTALLED_FLAG in ('I', 'B')
1206: and not exists
1207: (select NULL
1208: from GR_EUROHAZARDS_TL T

Line 1265: from GR_EUROHAZARDS_TL B, FND_LANGUAGES L

1261: B.LAST_UPDATE_LOGIN,
1262: B.HAZARD_CLASSIFICATION_CODE,
1263: L.LANGUAGE_CODE,
1264: B.SOURCE_LANG
1265: from GR_EUROHAZARDS_TL B, FND_LANGUAGES L
1266: where L.INSTALLED_FLAG in ('I', 'B')
1267: and B.LANGUAGE = userenv('LANG')
1268: and not exists
1269: (select NULL