APPS.GR_OTHER_NAMES_TL_PKG dependencies on FND_LANGUAGES

Line 405: FROM fnd_languages lng

401:
402: CURSOR c_get_installed_languages
403: IS
404: SELECT lng.language_code
405: FROM fnd_languages lng
406: WHERE lng.installed_flag IN ('I', 'B');
407: InstLang c_get_installed_languages%ROWTYPE;
408:
409:

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

477: l_last_updated_by := OtherNameDesc.last_updated_by;
478: l_last_update_date := OtherNameDesc.last_update_date;
479: l_last_update_login := OtherNameDesc.last_update_login;
480:
481: /* Read fnd_languages for the installed and base languages.
482: ** For those that are found, read the phrases tl table.
483: ** If there isn't a record in the table for that language then
484: ** insert it and go on to the next.
485: */

Line 962: FROM fnd_languages lng

958:
959: CURSOR c_get_language
960: IS
961: SELECT lng.language_code
962: FROM fnd_languages lng
963: WHERE lng.language_code = l_language_code;
964: LangRecord c_get_language%ROWTYPE;
965:
966: /* Organisation Codes */

Line 1096: FROM fnd_languages lng

1092:
1093: CURSOR c_get_language_code
1094: IS
1095: SELECT lng.installed_flag
1096: FROM fnd_languages lng
1097: WHERE lng.language_code = p_language
1098: AND lng.installed_flag IN ('B', 'I');
1099: LangRecord c_get_language_code%ROWTYPE;
1100:

Line 1284: from GR_OTHER_NAMES_TL B, FND_LANGUAGES L

1280: B.LAST_UPDATE_DATE,
1281: B.LAST_UPDATE_LOGIN,
1282: L.LANGUAGE_CODE,
1283: B.SOURCE_LANG
1284: from GR_OTHER_NAMES_TL B, FND_LANGUAGES L
1285: where L.INSTALLED_FLAG in ('I', 'B')
1286: and B.LANGUAGE = userenv('LANG')
1287: and not exists
1288: (select NULL