APPS.GR_ITEM_GROUPS_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 := GroupDesc.last_update_login;
429: CLOSE c_get_descs;
430: END IF;
431:
432: /* Read fnd_languages for the installed and base languages.
433: ** For those that are found, read the item groups 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 668: FROM fnd_languages lng

664:
665: CURSOR c_get_language_code
666: IS
667: SELECT lng.installed_flag
668: FROM fnd_languages lng
669: WHERE lng.language_code = p_language
670: AND lng.installed_flag IN ('I', 'B');
671: LangRecord c_get_language_code%ROWTYPE;
672:

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 938: FROM fnd_languages lng

934:
935: CURSOR c_get_language_code
936: IS
937: SELECT lng.installed_flag
938: FROM fnd_languages lng
939: WHERE lng.language_code = p_language
940: AND lng.installed_flag IN ('I', 'B');
941: LangRecord c_get_language_code%ROWTYPE;
942:

Line 1111: from GR_ITEM_GROUPS_TL B, FND_LANGUAGES L

1107: B.LAST_UPDATE_DATE,
1108: B.LAST_UPDATE_LOGIN,
1109: L.LANGUAGE_CODE,
1110: B.SOURCE_LANG
1111: from GR_ITEM_GROUPS_TL B, FND_LANGUAGES L
1112: where L.INSTALLED_FLAG in ('I', 'B')
1113: and B.LANGUAGE = userenv('LANG')
1114: and not exists
1115: (select NULL