APPS.GR_SAFETY_CATEGORIES_TL_PKG dependencies on FND_LANGUAGES

Line 366: FROM fnd_languages lng

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

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

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

Line 835: FROM fnd_languages lng

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

Line 930: FROM fnd_languages lng

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

Line 1177: from GR_SAFETY_CATEGORIES_TL B, FND_LANGUAGES L

1173: B.CREATION_DATE,
1174: B.CREATED_BY,
1175: L.LANGUAGE_CODE,
1176: B.SOURCE_LANG
1177: from GR_SAFETY_CATEGORIES_TL B, FND_LANGUAGES L
1178: where L.INSTALLED_FLAG in ('I', 'B')
1179: and B.LANGUAGE = userenv('LANG')
1180: and not exists
1181: (select NULL