APPS.GR_LABEL_CLASSES_TL_PKG dependencies on FND_LANGUAGES

Line 364: FROM fnd_languages lng

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

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

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

Line 833: FROM fnd_languages lng

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

Line 928: FROM fnd_languages lng

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

Line 1191: from FND_LANGUAGES L

1187: l_sysdate,
1188: 0,
1189: L.LANGUAGE_CODE,
1190: userenv('LANG')
1191: from FND_LANGUAGES L
1192: where L.INSTALLED_FLAG in ('I', 'B')
1193: and not exists
1194: (select NULL
1195: from GR_LABEL_CLASSES_TL T

Line 1258: from GR_LABEL_CLASSES_TL B, FND_LANGUAGES L

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