APPS.GR_DOCUMENT_CODES_TL_PKG dependencies on FND_LANGUAGES

Line 360: FROM fnd_languages lng

356:
357: CURSOR c_get_installed_languages
358: IS
359: SELECT lng.language_code
360: FROM fnd_languages lng
361: WHERE lng.installed_flag IN ('I', 'B');
362: InstLang c_get_installed_languages%ROWTYPE;
363:
364: BEGIN

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

426: l_last_update_login := TypeDesc.last_update_login;
427: CLOSE c_get_descs;
428: END IF;
429:
430: /* Read fnd_languages for the installed and base languages.
431: ** For those that are found, read the types 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 822: FROM fnd_languages lng

818: /* Cursors */
819: CURSOR c_get_language
820: IS
821: SELECT lng.language_code
822: FROM fnd_languages lng
823: WHERE lng.language_code = l_language_code;
824: LangRecord c_get_language%ROWTYPE;
825:
826: BEGIN

Line 918: FROM fnd_languages lng

914:
915: CURSOR c_get_language_code
916: IS
917: SELECT lng.installed_flag
918: FROM fnd_languages lng
919: WHERE lng.language_code = p_language
920: AND lng.installed_flag IN ('B', 'I');
921: LangRecord c_get_language_code%ROWTYPE;
922:

Line 1154: from GR_DOCUMENT_CODES_TL B, FND_LANGUAGES L

1150: B.LAST_UPDATE_DATE,
1151: B.LAST_UPDATE_LOGIN,
1152: L.LANGUAGE_CODE,
1153: B.SOURCE_LANG
1154: from GR_DOCUMENT_CODES_TL B, FND_LANGUAGES L
1155: where L.INSTALLED_FLAG in ('I', 'B')
1156: and B.LANGUAGE = userenv('LANG')
1157: and not exists
1158: (select NULL