APPS.FII_TIME_API SQL Statements

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

Line: 14

  select min(start_date)
  into l_date
  from fii_time_ent_year;

Line: 31

  select max(end_date)
  into l_date
  from fii_time_ent_year;

Line: 53

  select l_as_of_date-start_date, sequence
  into l_timespan, l_curr_year
  from fii_time_ent_year
  where l_as_of_date between start_date and end_date;

Line: 58

  select start_date+l_timespan
  into l_date
  from fii_time_ent_year
  where sequence=l_curr_year-1;

Line: 81

  select end_date-l_as_of_date, sequence
  into l_timespan, l_curr_year
  from fii_time_ent_year
  where l_as_of_date between start_date and end_date;

Line: 86

  select greatest(start_date, end_date-l_timespan)
  into l_date
  from fii_time_ent_year
  where sequence=l_curr_year-1;

Line: 109

  select l_as_of_date-start_date, sequence, ent_year_id
  into l_timespan, l_curr_qtr, l_curr_year
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 114

  select least(end_date, start_date+l_timespan)
  into l_date
  from fii_time_ent_qtr
  where sequence=l_curr_qtr
  and ent_year_id=l_curr_year-1;

Line: 138

  select end_date-l_as_of_date, sequence, ent_year_id
  into l_timespan, l_curr_qtr, l_curr_year
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 143

  select greatest(start_date, end_date-l_timespan)
  into l_date
  from fii_time_ent_qtr
  where sequence=l_curr_qtr
  and ent_year_id=l_curr_year-1;

Line: 167

  select l_as_of_date-start_date, sequence, ent_year_id
  into l_timespan, l_curr_qtr, l_curr_year
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 173

    select least(end_date, start_date+l_timespan)
    into l_date
    from fii_time_ent_qtr
    where sequence=4
    and ent_year_id=l_curr_year-1;

Line: 179

    select least(end_date, start_date+l_timespan)
    into l_date
    from fii_time_ent_qtr
    where sequence=l_curr_qtr-1
    and ent_year_id=l_curr_year;

Line: 204

  select end_date-l_as_of_date, sequence, ent_year_id
  into l_timespan, l_curr_qtr, l_curr_year
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 210

    select greatest(start_date, end_date-l_timespan)
    into l_date
    from fii_time_ent_qtr
    where sequence=4
    and ent_year_id=l_curr_year-1;

Line: 216

    select greatest(start_date, end_date-l_timespan)
    into l_date
    from fii_time_ent_qtr
    where sequence=l_curr_qtr-1
    and ent_year_id=l_curr_year;

Line: 241

  select l_as_of_date-p.start_date, p.sequence, p.ent_year_id
  into l_timespan, l_curr_period, l_curr_year
  from fii_time_ent_period p
  where l_as_of_date between p.start_date and p.end_date;

Line: 246

  select least(p.end_date, p.start_date+l_timespan)
  into l_date
  from fii_time_ent_period p
  where p.sequence=l_curr_period
  and p.ent_year_id=l_curr_year-1;

Line: 270

  select p.end_date-l_as_of_date, p.sequence, p.ent_year_id
  into l_timespan, l_curr_period, l_curr_year
  from fii_time_ent_period p
  where l_as_of_date between p.start_date and p.end_date;

Line: 275

  select greatest(p.start_date, p.end_date-l_timespan)
  into l_date
  from fii_time_ent_period p
  where p.sequence=l_curr_period
  and p.ent_year_id=l_curr_year-1;

Line: 300

  select l_as_of_date-p.start_date, p.sequence, p.ent_year_id
  into l_timespan, l_curr_period, l_curr_year
  from fii_time_ent_period p
  where l_as_of_date between p.start_date and p.end_date;

Line: 307

    select max(sequence) into l_max_sequence
    from fii_time_ent_period
    where ent_year_id = l_curr_year-1;

Line: 311

    select least(p.end_date, p.start_date+l_timespan)
    into l_date
    from fii_time_ent_period p
    where p.sequence=l_max_sequence
    and p.ent_year_id=l_curr_year-1;

Line: 317

    select least(p.end_date, p.start_date+l_timespan)
    into l_date
    from fii_time_ent_period p
    where p.sequence=l_curr_period-1
    and p.ent_year_id=l_curr_year;

Line: 343

  select p.end_date-l_as_of_date, p.sequence, p.ent_year_id
  into l_timespan, l_curr_period, l_curr_year
  from fii_time_ent_period p
  where l_as_of_date between p.start_date and p.end_date;

Line: 350

    select max(sequence) into l_max_sequence
    from fii_time_ent_period
    where ent_year_id = l_curr_year-1;

Line: 354

    select greatest(p.start_date, p.end_date-l_timespan)
    into l_date
    from fii_time_ent_period p
    where p.sequence=l_max_sequence
    and p.ent_year_id=l_curr_year-1;

Line: 360

    select greatest(p.start_date, p.end_date-l_timespan)
    into l_date
    from fii_time_ent_period p
    where p.sequence=l_curr_period-1
    and p.ent_year_id=l_curr_year;

Line: 386

  select l_as_of_date-w.start_date, w.sequence, p.year445_id
  into l_timespan, l_curr_week, l_curr_year
  from fii_time_week w, fii_time_p445 p
  where w.period445_id=p.period445_id
  and l_as_of_date between w.start_date and w.end_date;

Line: 394

  select max(w.sequence)
  into l_max_sequence
  from fii_time_week w, fii_time_p445 p
  where w.period445_id=p.period445_id
  and l_as_of_date between w.start_date and w.end_date;

Line: 406

    select w.start_date+l_timespan
    into l_date
    from fii_time_week w, fii_time_p445 p
    where w.period445_id=p.period445_id
    and w.sequence=l_curr_week
    and p.year445_id=l_curr_year-1;

Line: 415

    select w.start_date+l_timespan
    into l_date
    from fii_time_week w, fii_time_p445 p
    where w.period445_id=p.period445_id
    and w.sequence=l_curr_week - 1
    and p.year445_id=l_curr_year-1;

Line: 425

    select w.start_date+l_timespan
    into l_date
    from fii_time_week w, fii_time_p445 p
    where w.period445_id=p.period445_id
    and w.sequence=l_curr_week
    and p.year445_id=l_curr_year-1;

Line: 452

  select l_as_of_date-w.start_date, w.sequence, p.year445_id
  into l_timespan, l_curr_week, l_curr_year
  from fii_time_week w, fii_time_p445 p
  where w.period445_id=p.period445_id
  and l_as_of_date between w.start_date and w.end_date;

Line: 459

    select max(w.sequence)+1
    into l_curr_week
    from fii_time_week w, fii_time_p445 p
    where w.period445_id=p.period445_id
    and p.year445_id=l_curr_year-1;

Line: 468

  select w.start_date+l_timespan
  into l_date
  from fii_time_week w, fii_time_p445 p
  where w.period445_id=p.period445_id
  and w.sequence=l_curr_week-1
  and p.year445_id=l_curr_year;

Line: 490

  select start_date
  into l_date
  from fii_time_ent_year
  where l_as_of_date between start_date and end_date;

Line: 510

  select end_date
  into l_date
  from fii_time_ent_year
  where l_as_of_date between start_date and end_date;

Line: 533

    select start_date
    into l_date
    from fii_time_ent_year
    where sequence =
    (select sequence -1
     from fii_time_ent_year
     where l_as_of_date between start_date and end_date);

Line: 563

    select end_date
    into l_date
    from fii_time_ent_year
    where sequence =
    (select sequence -1
     from fii_time_ent_year
     where l_as_of_date between start_date and end_date);

Line: 590

  select start_date
  into l_date
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 610

  select end_date
  into l_date
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 632

  select sequence, ent_year_id
  into l_curr_qtr, l_curr_year
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 637

  select start_date
  into l_date
  from fii_time_ent_qtr
  where sequence=l_curr_qtr
  and ent_year_id=l_curr_year-1;

Line: 660

  select sequence, ent_year_id
  into l_curr_qtr, l_curr_year
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 665

  select end_date
  into l_date
  from fii_time_ent_qtr
  where sequence=l_curr_qtr
  and ent_year_id=l_curr_year-1;

Line: 689

  select sequence, ent_year_id
  into l_curr_qtr, l_curr_year
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 698

      select start_date
      into l_date
      from fii_time_ent_qtr
      where sequence=4
      and ent_year_id=l_curr_year-1;

Line: 704

      select start_date
      into l_date
      from fii_time_ent_qtr
      where sequence=l_curr_qtr-1
      and ent_year_id=l_curr_year;

Line: 733

  select sequence, ent_year_id
  into l_curr_qtr, l_curr_year
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 742

      select end_date
      into l_date
      from fii_time_ent_qtr
      where sequence=4
      and ent_year_id=l_curr_year-1;

Line: 748

      select end_date
      into l_date
      from fii_time_ent_qtr
      where sequence=l_curr_qtr-1
      and ent_year_id=l_curr_year;

Line: 774

  select start_date
  into l_date
  from fii_time_ent_period
  where l_as_of_date between start_date and end_date;

Line: 794

  select end_date
  into l_date
  from fii_time_ent_period
  where l_as_of_date between start_date and end_date;

Line: 816

  select p.sequence, p.ent_year_id
  into l_curr_period, l_curr_year
  from fii_time_ent_period p
  where l_as_of_date between p.start_date and p.end_date;

Line: 821

  select p.start_date
  into l_date
  from fii_time_ent_period p
  where p.sequence=l_curr_period
  and p.ent_year_id=l_curr_year-1;

Line: 844

  select p.sequence, p.ent_year_id
  into l_curr_period, l_curr_year
  from fii_time_ent_period p
  where l_as_of_date between p.start_date and p.end_date;

Line: 849

  select p.end_date
  into l_date
  from fii_time_ent_period p
  where p.sequence=l_curr_period
  and p.ent_year_id=l_curr_year-1;

Line: 874

  select p.sequence, p.ent_year_id
  into l_curr_period, l_curr_year
  from fii_time_ent_period p
  where l_as_of_date between p.start_date and p.end_date;

Line: 884

      select max(sequence) into l_max_sequence
      from fii_time_ent_period
      where ent_year_id = l_curr_year-1;

Line: 888

      select p.start_date
      into l_date
      from fii_time_ent_period p
      where p.sequence=l_max_sequence
      and p.ent_year_id=l_curr_year-1;

Line: 894

      select p.start_date
      into l_date
      from fii_time_ent_period p
      where p.sequence=l_curr_period-1
      and p.ent_year_id=l_curr_year;

Line: 924

  select p.sequence, p.ent_year_id
  into l_curr_period, l_curr_year
  from fii_time_ent_period p
  where l_as_of_date between p.start_date and p.end_date;

Line: 934

      select max(sequence) into l_max_sequence
      from fii_time_ent_period
      where ent_year_id = l_curr_year-1;

Line: 938

      select p.end_date
      into l_date
      from fii_time_ent_period p
      where p.sequence=l_max_sequence
      and p.ent_year_id=l_curr_year-1;

Line: 944

      select p.end_date
      into l_date
      from fii_time_ent_period p
      where p.sequence=l_curr_period-1
      and p.ent_year_id=l_curr_year;

Line: 970

  select start_date
  into l_date
  from fii_time_week
  where l_as_of_date between start_date and end_date;

Line: 990

  select end_date
  into l_date
  from fii_time_week
  where l_as_of_date between start_date and end_date;

Line: 1012

  select w.sequence, p.year445_id
  into l_curr_week, l_curr_year
  from fii_time_week w, fii_time_p445 p
  where w.period445_id=p.period445_id
  and l_as_of_date between w.start_date and w.end_date;

Line: 1018

  select w.start_date
  into l_date
  from fii_time_week w, fii_time_p445 p
  where w.period445_id=p.period445_id
  and w.sequence=l_curr_week
  and p.year445_id=l_curr_year-1;

Line: 1042

  select w.sequence, p.year445_id
  into l_curr_week, l_curr_year
  from fii_time_week w, fii_time_p445 p
  where w.period445_id=p.period445_id
  and l_as_of_date between w.start_date and w.end_date;

Line: 1048

  select w.end_date
  into l_date
  from fii_time_week w, fii_time_p445 p
  where w.period445_id=p.period445_id
  and w.sequence=l_curr_week
  and p.year445_id=l_curr_year-1;

Line: 1073

  select w.sequence, p.year445_id
  into l_curr_week, l_curr_year
  from fii_time_week w, fii_time_p445 p
  where w.period445_id=p.period445_id
  and l_as_of_date between w.start_date and w.end_date;

Line: 1083

      select max(w.sequence)+1
      into l_curr_week
      from fii_time_week w, fii_time_p445 p
      where w.period445_id=p.period445_id
      and p.year445_id=l_curr_year-1;

Line: 1092

    select w.start_date
    into l_date
    from fii_time_week w, fii_time_p445 p
    where w.period445_id=p.period445_id
    and w.sequence=l_curr_week-1
    and p.year445_id=l_curr_year;

Line: 1121

  select w.sequence, p.year445_id
  into l_curr_week, l_curr_year
  from fii_time_week w, fii_time_p445 p
  where w.period445_id=p.period445_id
  and l_as_of_date between w.start_date and w.end_date;

Line: 1131

      select max(w.sequence)+1
      into l_curr_week
      from fii_time_week w, fii_time_p445 p
      where w.period445_id=p.period445_id
      and p.year445_id=l_curr_year-1;

Line: 1140

    select w.end_date
    into l_date
    from fii_time_week w, fii_time_p445 p
    where w.period445_id=p.period445_id
    and w.sequence=l_curr_week-1
    and p.year445_id=l_curr_year;

Line: 1167

    select l_as_of_date - 29
    into l_date
    from dual;

Line: 1187

    select l_as_of_date - 89
    into l_date
    from dual;

Line: 1207

    select l_as_of_date - 364
    into l_date
    from dual;

Line: 1227

    select l_as_of_date-6
    into l_date
    from dual;

Line: 1251

  select to_char(ent_cqtr_end(l_as_of_date)-l_as_of_date)
  into l_day_left
  from dual;

Line: 1255

  select sequence
  into l_qtr
  from fii_time_ent_qtr
  where l_as_of_date between start_date and end_date;

Line: 1260

  select to_char(to_date(ent_year_id,'yyyy'),'yy')
  into l_yr
  from fii_time_ent_year
  where l_as_of_date between start_date and end_date;

Line: 1295

  select sequence, ent_year_id
  into l_curr_period, l_curr_year
  from fii_time_ent_period
  where ent_period_id=id;

Line: 1300

  select ent_period_id
  into l_id
  from fii_time_ent_period
  where sequence=l_curr_period
  and ent_year_id=l_curr_year-1;

Line: 1368

     select count(*) into l_count
     from   fii_time_day
     where  report_date = trunc(l_day);

Line: 1458

     select count(*) into l_count
     from   fii_time_day
     where  report_date = trunc(l_day);

Line: 1502

   select end_date-l_as_of_date, sequence
   into l_timespan, l_curr_year
   from fii_time_cal_year
   where l_as_of_date between start_date and end_date
   and calendar_id=p_calendar_id;

Line: 1508

   select end_date-l_timespan
   into l_date
   from fii_time_cal_year
   where sequence=l_curr_year-1
   and calendar_id=p_calendar_id;

Line: 1532

   select end_date-l_as_of_date, sequence, cal_year_id
   into l_timespan, l_curr_qtr, l_curr_year
   from fii_time_cal_qtr
   where l_as_of_date between start_date and end_date
   and calendar_id=p_calendar_id;

Line: 1538

   select greatest(start_date, end_date-l_timespan)
   into l_date
   from fii_time_cal_qtr
   where sequence=l_curr_qtr
   and cal_year_id=l_curr_year-1
   and calendar_id=p_calendar_id;

Line: 1563

   select p.end_date-l_as_of_date, p.sequence, q.cal_year_id
   into l_timespan, l_curr_period, l_curr_year
   from fii_time_cal_period p, fii_time_cal_qtr q
   where p.cal_qtr_id=q.cal_qtr_id
   and q.calendar_id=p_calendar_id
   and p.calendar_id=q.calendar_id
   and l_as_of_date between p.start_date and p.end_date;

Line: 1571

   select greatest(p.start_date, p.end_date-l_timespan)
   into l_date
   from fii_time_cal_period p, fii_time_cal_qtr q
   where p.cal_qtr_id=q.cal_qtr_id
   and q.calendar_id=p_calendar_id
   and p.calendar_id=q.calendar_id
   and p.sequence=l_curr_period
   and q.cal_year_id=l_curr_year-1;

Line: 1598

   select end_date-l_as_of_date, sequence, cal_year_id
   into l_timespan, l_curr_qtr, l_curr_year
   from fii_time_cal_qtr
   where l_as_of_date between start_date and end_date
   and calendar_id=p_calendar_id;

Line: 1605

     select end_date-l_timespan
     into l_date
     from fii_time_cal_qtr
     where sequence=4
     and calendar_id=p_calendar_id
     and cal_year_id=l_curr_year-1;

Line: 1612

     select end_date-l_timespan
     into l_date
     from fii_time_cal_qtr
     where sequence=l_curr_qtr-1
     and calendar_id=p_calendar_id
     and cal_year_id=l_curr_year;

Line: 1638

   select p.end_date-l_as_of_date, p.sequence -1 , q.cal_year_id
   into l_timespan, l_curr_period, l_curr_year
   from fii_time_cal_period p, fii_time_cal_qtr q
   where p.cal_qtr_id=q.cal_qtr_id
   and q.calendar_id=p_calendar_id
   and p.calendar_id=q.calendar_id
   and l_as_of_date between p.start_date and p.end_date;

Line: 1649

     select count(cal_period_id)
     into l_curr_period
     from fii_time_cal_period p, fii_time_cal_qtr q
     where p.cal_qtr_id=q.cal_qtr_id
     and q.calendar_id=p_calendar_id
     and p.calendar_id=q.calendar_id
     and q.cal_year_id=l_curr_year;

Line: 1658

   select p.end_date-l_timespan
   into l_date
   from fii_time_cal_period p, fii_time_cal_qtr q
   where p.cal_qtr_id=q.cal_qtr_id
   and p.sequence=l_curr_period
   and q.calendar_id=p_calendar_id
   and p.calendar_id=q.calendar_id
   and q.cal_year_id=l_curr_year;

Line: 1686

    select sequence
    into l_curr_year
    from fii_time_ent_year
    where l_as_of_date between start_date and end_date;

Line: 1691

    select min(start_date)
    into l_date
    from fii_time_ent_year
    where sequence>=l_curr_year-3;

Line: 1698

    select min(start_date)
    into l_date
    from
    (select *
     from fii_time_ent_qtr
     where start_date <= l_as_of_date
     order by start_date desc)
    where rownum < 5;

Line: 1709

    select min(start_date)
    into l_date
    from
    (select *
     from fii_time_ent_period
     where start_date <= l_as_of_date
     order by start_date desc)
    where rownum < 14;

Line: 1721

   select start_date-7*12
   into l_date
   from fii_time_week
   where l_as_of_date between start_date and end_date;

Line: 1748

    select end_date
    into l_date
    from fii_time_ent_year
    where sequence =
    (select sequence + 1
     from fii_time_ent_year
     where l_as_of_date between start_date and end_date);

Line: 1758

    select end_date
    into l_date
    from fii_time_ent_qtr next,
    (select sequence, ent_year_id
     from fii_time_ent_qtr
     where l_as_of_date between start_date and end_date) curr
    where next.sequence = decode(curr.sequence, 4, 1, curr.sequence + 1)
    and next.ent_year_id = decode(curr.sequence, 4, curr.ent_year_id+1, curr.ent_year_id);

Line: 1770

    select max(sequence) into l_max_sequence
    from fii_time_ent_period
    where ent_year_id = (select ent_year_id
			 from fii_time_ent_period
			 where l_as_of_date between start_date and end_date);

Line: 1776

    select end_date
    into l_date
    from fii_time_ent_period next,
    (select sequence, ent_year_id
     from fii_time_ent_period
     where l_as_of_date between start_date and end_date) curr
    where next.sequence = decode(curr.sequence, l_max_sequence, 1, curr.sequence + 1)
    and next.ent_year_id = decode(curr.sequence, l_max_sequence, curr.ent_year_id+1, curr.ent_year_id);

Line: 1787

   select end_date+7
   into l_date
   from fii_time_week
   where l_as_of_date between start_date and end_date;