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)) order by 1
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)) ORDER BY 1
|
|
|