SELECT mp.organization_id id, hrtl.name value FROM mtl_parameters mp, hr_all_organization_units_tl hrtl WHERE mp.organization_id = hrtl.organization_id and hrtl.language = userenv('LANG')
View Text - HTML Formatted
SELECT MP.ORGANIZATION_ID ID , HRTL.NAME VALUE FROM MTL_PARAMETERS MP , HR_ALL_ORGANIZATION_UNITS_TL HRTL WHERE MP.ORGANIZATION_ID = HRTL.ORGANIZATION_ID AND HRTL.LANGUAGE = USERENV('LANG')