PA Service Types

select LOOKUP_CODE, description, START_DATE_ACTIVE,
       END_DATE_ACTIVE
from
    PA_LOOKUPS L
where 
    LOOKUP_TYPE = 'SERVICE TYPE'
order by 
    LOOKUP_CODE,
    START_DATE_ACTIVE