SELECT budget_type_code ,budget_type FROM pa_budget_types WHERE budget_amount_code = 'C' AND trunc(sysdate) between trunc(start_date_active) and trunc(nvl(end_date_active,sysdate))
View Text - HTML Formatted
SELECT BUDGET_TYPE_CODE , BUDGET_TYPE FROM PA_BUDGET_TYPES WHERE BUDGET_AMOUNT_CODE = 'C' AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE_ACTIVE) AND TRUNC(NVL(END_DATE_ACTIVE , SYSDATE))