1500: begin
1501: l_as_of_date := trunc(as_of_date);
1502: select end_date-l_as_of_date, sequence
1503: into l_timespan, l_curr_year
1504: from fii_time_cal_year
1505: where l_as_of_date between start_date and end_date
1506: and calendar_id=p_calendar_id;
1507:
1508: select end_date-l_timespan
1506: and calendar_id=p_calendar_id;
1507:
1508: select end_date-l_timespan
1509: into l_date
1510: from fii_time_cal_year
1511: where sequence=l_curr_year-1
1512: and calendar_id=p_calendar_id;
1513:
1514: return l_date;