SELECT BUDGET_TYPE_CODE , BUDGET_TYPE , 'Y' FROM PA_BUDGET_TYPES WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE)) UNION ALL SELECT LOOKUP_CODE , MEANING , 'N' FROM PA_LOOKUPS WHERE LOOKUP_TYPE = 'RESOURCE_LIST_USES' AND TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE)) UNION ALL SELECT TO_CHAR(FIN_PLAN_TYPE_ID) , NAME , 'Y' FROM PA_FIN_PLAN_TYPES_VL WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE))