APPS.GR_COVER_LETTERS_TL_PKG dependencies on FND_LANGUAGES

Line 375: FROM fnd_languages lng

371:
372: CURSOR c_get_installed_languages
373: IS
374: SELECT lng.language_code
375: FROM fnd_languages lng
376: WHERE lng.installed_flag IN ('I', 'B');
377: InstLang c_get_installed_languages%ROWTYPE;
378:
379:

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

443: l_last_update_login := CoverLetter.last_update_login;
444: CLOSE c_get_cover_letter;
445: END IF;
446:
447: /* Read fnd_languages for the installed and base languages.
448: ** For those that are found, read the phrases tl table.
449: ** If there isn't a record in the table for that language then
450: ** insert it and go on to the next.
451: */

Line 858: FROM fnd_languages lng

854:
855: CURSOR c_get_language
856: IS
857: SELECT lng.language_code
858: FROM fnd_languages lng
859: WHERE lng.language_code = l_language_code;
860: LangRecord c_get_language%ROWTYPE;
861:
862: BEGIN

Line 955: FROM fnd_languages lng

951:
952: CURSOR c_get_language_code
953: IS
954: SELECT lng.installed_flag
955: FROM fnd_languages lng
956: WHERE lng.language_code = p_language
957: AND lng.installed_flag IN ('B', 'I');
958: LangRecord c_get_language_code%ROWTYPE;
959:

Line 1212: from GR_COVER_LETTERS_TL B, FND_LANGUAGES L

1208: B.LAST_UPDATED_BY,
1209: B.LAST_UPDATE_LOGIN,
1210: L.LANGUAGE_CODE,
1211: B.SOURCE_LANG
1212: from GR_COVER_LETTERS_TL B, FND_LANGUAGES L
1213: where L.INSTALLED_FLAG in ('I', 'B')
1214: and B.LANGUAGE = userenv('LANG')
1215: and not exists
1216: (select NULL