109: X_Nav_Unit_Id,
110: x_default_label,
111: l.language_code,
112: userenv('LANG')
113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from HR_NAVIGATION_UNITS_TL T
404: B.NAV_UNIT_ID,
405: B.DEFAULT_LABEL,
406: L.LANGUAGE_CODE,
407: B.SOURCE_LANG
408: from HR_NAVIGATION_UNITS_TL B, FND_LANGUAGES L
409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL