SELECT LOOKUP_CODE , MEANING , 'N' , NULL , 'N' FROM PA_LOOKUPS PL WHERE LOOKUP_TYPE = 'EVENT TYPE CLASSIFICATION' AND LOOKUP_CODE IN ('AUTOMATIC' , 'MANUAL' , 'WRITE OFF' , 'WRITE ON') AND DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES , 'Y' , START_DATE_ACTIVE , TRUNC(SYSDATE)) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE))