APPS.GR_PROPERTY_VALUES_TL_PKG dependencies on FND_LANGUAGES

Line 398: FROM fnd_languages lng

394:
395: CURSOR c_get_installed_languages
396: IS
397: SELECT lng.language_code
398: FROM fnd_languages lng
399: WHERE lng.installed_flag IN ('I', 'B');
400: InstLang c_get_installed_languages%ROWTYPE;
401:
402:

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

463: l_last_updated_by := PropertyDesc.last_updated_by;
464: l_last_update_date := PropertyDesc.last_update_date;
465: l_last_update_login := PropertyDesc.last_update_login;
466:
467: /* Read fnd_languages for the installed and base languages.
468: ** For those that are found, read the values table.
469: ** If there isn't a record in the table for that language then
470: ** insert it and go on to the next.
471: */

Line 878: FROM fnd_languages lng

874:
875: CURSOR c_get_language
876: IS
877: SELECT lng.language_code
878: FROM fnd_languages lng
879: WHERE lng.language_code = l_language_code;
880: LangRecord c_get_language%ROWTYPE;
881:
882: BEGIN

Line 979: FROM fnd_languages lng

975:
976: CURSOR c_get_language_code
977: IS
978: SELECT lng.installed_flag
979: FROM fnd_languages lng
980: WHERE lng.language_code = p_language
981: AND lng.installed_flag IN ('B', 'I');
982: LangRecord c_get_language_code%ROWTYPE;
983:

Line 1239: from GR_PROPERTY_VALUES_TL B, FND_LANGUAGES L

1235: B.LAST_UPDATE_DATE,
1236: B.LAST_UPDATE_LOGIN,
1237: L.LANGUAGE_CODE,
1238: B.SOURCE_LANG
1239: from GR_PROPERTY_VALUES_TL B, FND_LANGUAGES L
1240: where L.INSTALLED_FLAG in ('I', 'B')
1241: and B.LANGUAGE = userenv('LANG')
1242: and not exists
1243: (select NULL