APPS.GR_EIN_NUMBERS_TL_PKG dependencies on FND_LANGUAGES

Line 360: FROM fnd_languages lng

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

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

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

Line 817: FROM fnd_languages lng

813: /* Cursors */
814: CURSOR c_get_language
815: IS
816: SELECT lng.language_code
817: FROM fnd_languages lng
818: WHERE lng.language_code = l_language_code;
819: LangRecord c_get_language%ROWTYPE;
820:
821: BEGIN

Line 913: FROM fnd_languages lng

909:
910: CURSOR c_get_language_code
911: IS
912: SELECT lng.installed_flag
913: FROM fnd_languages lng
914: WHERE lng.language_code = p_language
915: AND lng.installed_flag IN ('B', 'I');
916: LangRecord c_get_language_code%ROWTYPE;
917:

Line 1079: from GR_EIN_NUMBERS_TL B, FND_LANGUAGES L

1075: B.LAST_UPDATE_LOGIN,
1076: B.EUROPEAN_INDEX_NUMBER,
1077: L.LANGUAGE_CODE,
1078: B.SOURCE_LANG
1079: from GR_EIN_NUMBERS_TL B, FND_LANGUAGES L
1080: where L.INSTALLED_FLAG in ('I', 'B')
1081: and B.LANGUAGE = userenv('LANG')
1082: and not exists
1083: (select NULL