APPS.GR_PHRASES_TL_PKG dependencies on FND_LANGUAGES

Line 734: FROM fnd_languages lng

730:
731: CURSOR c_get_installed_languages
732: IS
733: SELECT lng.language_code
734: FROM fnd_languages lng
735: WHERE lng.installed_flag IN ('I', 'B');
736: InstLang c_get_installed_languages%ROWTYPE;
737:
738:

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

837: l_last_update_login := PhraseDesc.last_update_login;
838: CLOSE c_get_descs;
839: END IF;
840:
841: /* Read fnd_languages for the installed and base languages.
842: ** For those that are found, read the phrases tl table.
843: ** If there isn't a record in the table for that language then
844: ** insert it and go on to the next.
845: */

Line 1500: FROM fnd_languages lng

1496:
1497: CURSOR c_get_language
1498: IS
1499: SELECT lng.language_code
1500: FROM fnd_languages lng
1501: WHERE lng.language_code = l_language_code;
1502: LangRecord c_get_language%ROWTYPE;
1503:
1504: BEGIN

Line 1636: FROM fnd_languages lng

1632:
1633: CURSOR c_get_language_code
1634: IS
1635: SELECT lng.installed_flag
1636: FROM fnd_languages lng
1637: WHERE lng.language_code = p_language
1638: AND lng.installed_flag IN ('B', 'I');
1639: LangRecord c_get_language_code%ROWTYPE;
1640:

Line 2068: from GR_PHRASES_TL B, FND_LANGUAGES L

2064: B.PRINT_SIZE,
2065: B.IMAGE_PATHNAME,
2066: L.LANGUAGE_CODE,
2067: B.SOURCE_LANG
2068: from GR_PHRASES_TL B, FND_LANGUAGES L
2069: where L.INSTALLED_FLAG in ('I', 'B')
2070: and B.LANGUAGE = userenv('LANG')
2071: and not exists
2072: (select NULL