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

427: l_last_update_login := PhraseDesc.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 risk 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 839: FROM fnd_languages lng

835:
836: CURSOR c_get_language
837: IS
838: SELECT lng.language_code
839: FROM fnd_languages lng
840: WHERE lng.language_code = l_language_code;
841: LangRecord c_get_language%ROWTYPE;
842:
843: 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 ('B', 'I');
932: LangRecord c_get_language_code%ROWTYPE;
933:

Line 1192: from FND_LANGUAGES L

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

Line 1256: from GR_RISK_PHRASES_TL B, FND_LANGUAGES L

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