127: X_Nav_Path_Id,
128: x_override_label,
129: l.language_code,
130: userenv('LANG')
131: from FND_LANGUAGES L
132: where L.INSTALLED_FLAG in ('I', 'B')
133: and not exists
134: (select NULL
135: from HR_NAVIGATION_PATHS_TL T
307: B.NAV_PATH_ID,
308: B.OVERRIDE_LABEL,
309: L.LANGUAGE_CODE,
310: B.SOURCE_LANG
311: from HR_NAVIGATION_PATHS_TL B, FND_LANGUAGES L
312: where L.INSTALLED_FLAG in ('I', 'B')
313: and B.LANGUAGE = userenv('LANG')
314: and not exists
315: (select NULL