APPS.GR_EXPOSURE_AUTHS_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:

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

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

Line 843: FROM fnd_languages lng

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

Line 942: FROM fnd_languages lng

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

Line 1187: from GR_EXPOSURE_AUTHS_TL B, FND_LANGUAGES L

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