SELECT ind_rate_sch_name , ind_rate_sch_id from pa_ind_rate_schedules WHERE trunc(sysdate) between start_date_active and decode(end_date_active, null, sysdate+1, end_date_active)
View Text - HTML Formatted
SELECT IND_RATE_SCH_NAME , IND_RATE_SCH_ID FROM PA_IND_RATE_SCHEDULES WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND DECODE(END_DATE_ACTIVE , NULL , SYSDATE+1 , END_DATE_ACTIVE)