SELECT BUDGET_TYPE_CODE , BUDGET_TYPE , DESCRIPTION , BUDGET_AMOUNT_CODE , PREDEFINED_FLAG , ACCUMULATION_FLAG FROM PA_BUDGET_TYPES WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE)) UNION SELECT NAME , NAME , DESCRIPTION , 'DEFAULT' , PRE_DEFINED_FLAG , NULL FROM PA_FIN_PLAN_TYPES_VL WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE))