DBA Data[Home] [Help]

VIEW: APPS.IGW_IDC_SCHEDULE_V

Source

View Text - Preformatted

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)