APPS.GR_PROPERTIES_TL_PKG dependencies on FND_LANGUAGES

Line 365: FROM fnd_languages lng

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

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

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

Line 834: FROM fnd_languages lng

830:
831: CURSOR c_get_language
832: IS
833: SELECT lng.language_code
834: FROM fnd_languages lng
835: WHERE lng.language_code = l_language_code;
836: LangRecord c_get_language%ROWTYPE;
837:
838: BEGIN

Line 929: FROM fnd_languages lng

925:
926: CURSOR c_get_language_code
927: IS
928: SELECT lng.installed_flag
929: FROM fnd_languages lng
930: WHERE lng.language_code = p_language
931: AND lng.installed_flag IN ('I', 'B');
932: LangRecord c_get_language_code%ROWTYPE;
933:

Line 1196: from FND_LANGUAGES L

1192: l_sysdate,
1193: 0,
1194: L.LANGUAGE_CODE,
1195: userenv('LANG')
1196: from FND_LANGUAGES L
1197: where L.INSTALLED_FLAG in ('I', 'B')
1198: and not exists
1199: (select NULL
1200: from GR_PROPERTIES_TL T

Line 1261: from GR_PROPERTIES_TL B, FND_LANGUAGES L

1257: B.LAST_UPDATE_DATE,
1258: B.LAST_UPDATE_LOGIN,
1259: L.LANGUAGE_CODE,
1260: B.SOURCE_LANG
1261: from GR_PROPERTIES_TL B, FND_LANGUAGES L
1262: where L.INSTALLED_FLAG in ('I', 'B')
1263: and B.LANGUAGE = userenv('LANG')
1264: and not exists
1265: (select NULL