SELECT irs.ind_rate_sch_id , irs.ind_rate_sch_name FROM pa_ind_rate_schedules irs WHERE irs.project_id is null AND trunc(sysdate) between trunc(irs.start_date_active ) AND nvl (irs.end_date_active,trunc(sysdate))
View Text - HTML Formatted
SELECT IRS.IND_RATE_SCH_ID , IRS.IND_RATE_SCH_NAME FROM PA_IND_RATE_SCHEDULES IRS WHERE IRS.PROJECT_ID IS NULL AND TRUNC(SYSDATE) BETWEEN TRUNC(IRS.START_DATE_ACTIVE ) AND NVL (IRS.END_DATE_ACTIVE , TRUNC(SYSDATE))