DBA Data[Home] [Help]

APPS.JTF_NAV_TREE_ROOTS_PKG dependencies on FND_LANGUAGES

Line 61: from FND_LANGUAGES L

57: X_LAST_UPDATE_DATE,
58: X_LAST_UPDATED_BY,
59: L.LANGUAGE_CODE,
60: userenv('LANG')
61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from JTF_NAV_TREE_ROOTS_TL T

Line 231: from JTF_NAV_TREE_ROOTS_TL B, FND_LANGUAGES L

227: B.LAST_UPDATE_DATE,
228: B.LAST_UPDATED_BY,
229: L.LANGUAGE_CODE,
230: B.SOURCE_LANG
231: from JTF_NAV_TREE_ROOTS_TL B, FND_LANGUAGES L
232: where L.INSTALLED_FLAG in ('I', 'B')
233: and B.LANGUAGE = userenv('LANG')
234: and not exists
235: (select NULL

Line 353: FROM fnd_languages l

349: user_id,
350: 0,
351: l.language_code,
352: userenv('LANG')
353: FROM fnd_languages l
354: WHERE l.installed_flag IN ('I', 'B')
355: AND NOT EXISTS
356: (SELECT NULL
357: FROM jtf_nav_tree_roots_tl t