SELECT DISTINCT T.NAME , T.DESCRIPTION FROM JTF_TASK_TYPES_VL T , JTF_OBJECT_MAPPINGS S WHERE TO_CHAR(T.TASK_TYPE_ID) = S.OBJECT_ID AND S.OBJECT_CODE = 'JTF_TASK_TYPE' AND S.SOURCE_OBJECT_CODE = 'DR' AND T.TASK_TYPE_ID !=22 AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(T.START_DATE_ACTIVE , SYSDATE))AND TRUNC(NVL(T.END_DATE_ACTIVE , SYSDATE))AND NVL(S.END_DATE , SYSDATE+1) >= SYSDATE ORDER BY 1