APPS.GR_SAFETY_PHRASES_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 433: /* Read fnd_languages for the installed and base languages.

429: l_last_update_login := PhraseDesc.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 safety phrase 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 848: FROM fnd_languages lng

844:
845: CURSOR c_get_language
846: IS
847: SELECT lng.language_code
848: FROM fnd_languages lng
849: WHERE lng.language_code = l_language_code;
850: LangRecord c_get_language%ROWTYPE;
851:
852: 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 ('B', 'I');
945: LangRecord c_get_language_code%ROWTYPE;
946:

Line 1205: from FND_LANGUAGES L

1201: l_sysdate,
1202: 0,
1203: L.LANGUAGE_CODE,
1204: userenv('LANG')
1205: from FND_LANGUAGES L
1206: where L.INSTALLED_FLAG in ('I', 'B')
1207: and not exists
1208: (select NULL
1209: from GR_SAFETY_PHRASES_TL T

Line 1269: from GR_SAFETY_PHRASES_TL B, FND_LANGUAGES L

1265: B.LAST_UPDATE_DATE,
1266: B.LAST_UPDATE_LOGIN,
1267: L.LANGUAGE_CODE,
1268: B.SOURCE_LANG
1269: from GR_SAFETY_PHRASES_TL B, FND_LANGUAGES L
1270: where L.INSTALLED_FLAG in ('I', 'B')
1271: and B.LANGUAGE = userenv('LANG')
1272: and not exists
1273: (select NULL