[Home] [Help]
1561: begin
1562: l_as_of_date := trunc(as_of_date);
1563: select p.end_date-l_as_of_date, p.sequence, q.cal_year_id
1564: into l_timespan, l_curr_period, l_curr_year
1565: from fii_time_cal_period p, fii_time_cal_qtr q
1566: where p.cal_qtr_id=q.cal_qtr_id
1567: and q.calendar_id=p_calendar_id
1568: and p.calendar_id=q.calendar_id
1569: and l_as_of_date between p.start_date and p.end_date;
1569: and l_as_of_date between p.start_date and p.end_date;
1570:
1571: select greatest(p.start_date, p.end_date-l_timespan)
1572: into l_date
1573: from fii_time_cal_period p, fii_time_cal_qtr q
1574: where p.cal_qtr_id=q.cal_qtr_id
1575: and q.calendar_id=p_calendar_id
1576: and p.calendar_id=q.calendar_id
1577: and p.sequence=l_curr_period
1636: begin
1637: l_as_of_date := trunc(as_of_date);
1638: select p.end_date-l_as_of_date, p.sequence -1 , q.cal_year_id
1639: into l_timespan, l_curr_period, l_curr_year
1640: from fii_time_cal_period p, fii_time_cal_qtr q
1641: where p.cal_qtr_id=q.cal_qtr_id
1642: and q.calendar_id=p_calendar_id
1643: and p.calendar_id=q.calendar_id
1644: and l_as_of_date between p.start_date and p.end_date;
1647: l_curr_year:=l_curr_year-1;
1648:
1649: select count(cal_period_id)
1650: into l_curr_period
1651: from fii_time_cal_period p, fii_time_cal_qtr q
1652: where p.cal_qtr_id=q.cal_qtr_id
1653: and q.calendar_id=p_calendar_id
1654: and p.calendar_id=q.calendar_id
1655: and q.cal_year_id=l_curr_year;
1656: end if;
1657:
1658: select p.end_date-l_timespan
1659: into l_date
1660: from fii_time_cal_period p, fii_time_cal_qtr q
1661: where p.cal_qtr_id=q.cal_qtr_id
1662: and p.sequence=l_curr_period
1663: and q.calendar_id=p_calendar_id
1664: and p.calendar_id=q.calendar_id