To Find the organization clasificaitons

SELECT hl.meaning, hl.lookup_code
FROM hr_lookups hl
WHERE hl.lookup_type = 'ORG_CLASS'
AND hl.enabled_flag = 'Y'
AND trunc(SYSDATE) BETWEEN nvl(hl.start_date_active
,trunc(SYSDATE)) AND
nvl(hl.end_date_active
,trunc(SYSDATE))
ORDER BY meaning