APPS.FII_TIME_WH_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 41

  select trunc(min(least(ecqr_start_date, cqtr_start_date))),
	 trunc(max(greatest(ecqr_end_date, cqtr_end_date))),
	 trunc(min(ecqr_start_date)),
	 trunc(max(ecqr_end_date)),
    trunc(min(ecyr_start_date)),
    trunc(max(ecyr_end_date))
  from	 edw_time_m
  where	 cday_calendar_date = trunc(sysdate);

Line: 51

  select trunc(min(ecqr_start_date)),
	 trunc(max(ecqr_end_date)),
    trunc(min(ecyr_start_date)),
    trunc(max(ecyr_end_date))
  from	 edw_time_m
  where	 cday_calendar_date = add_months(trunc(sysdate), -12);

Line: 59

  select cal_qtr_pk_key
  from edw_time_ep_cal_qtr_ltc
  where start_date = (
          select trunc(min(ecqr_start_date))
          from   edw_time_m
          where  cday_calendar_date = trunc(sysdate));

Line: 67

  select month_pk_key
  from edw_time_month_ltc
  where start_date = (select trunc(min(mnth_start_date))
                      from edw_time_m
                      where  cday_calendar_date = trunc(sysdate));