APPS.FII_TIME_API dependencies on FII_TIME_CAL_QTR

Line 1534: from fii_time_cal_qtr

1530: begin
1531: l_as_of_date := trunc(as_of_date);
1532: select end_date-l_as_of_date, sequence, cal_year_id
1533: into l_timespan, l_curr_qtr, l_curr_year
1534: from fii_time_cal_qtr
1535: where l_as_of_date between start_date and end_date
1536: and calendar_id=p_calendar_id;
1537:
1538: select greatest(start_date, end_date-l_timespan)

Line 1540: from fii_time_cal_qtr

1536: and calendar_id=p_calendar_id;
1537:
1538: select greatest(start_date, end_date-l_timespan)
1539: into l_date
1540: from fii_time_cal_qtr
1541: where sequence=l_curr_qtr
1542: and cal_year_id=l_curr_year-1
1543: and calendar_id=p_calendar_id;
1544:

Line 1565: from fii_time_cal_period p, fii_time_cal_qtr q

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;

Line 1573: from fii_time_cal_period p, fii_time_cal_qtr q

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

Line 1600: from fii_time_cal_qtr

1596: begin
1597: l_as_of_date := trunc(as_of_date);
1598: select end_date-l_as_of_date, sequence, cal_year_id
1599: into l_timespan, l_curr_qtr, l_curr_year
1600: from fii_time_cal_qtr
1601: where l_as_of_date between start_date and end_date
1602: and calendar_id=p_calendar_id;
1603:
1604: if l_curr_qtr=1 then

Line 1607: from fii_time_cal_qtr

1603:
1604: if l_curr_qtr=1 then
1605: select end_date-l_timespan
1606: into l_date
1607: from fii_time_cal_qtr
1608: where sequence=4
1609: and calendar_id=p_calendar_id
1610: and cal_year_id=l_curr_year-1;
1611: else

Line 1614: from fii_time_cal_qtr

1610: and cal_year_id=l_curr_year-1;
1611: else
1612: select end_date-l_timespan
1613: into l_date
1614: from fii_time_cal_qtr
1615: where sequence=l_curr_qtr-1
1616: and calendar_id=p_calendar_id
1617: and cal_year_id=l_curr_year;
1618: end if;

Line 1640: from fii_time_cal_period p, fii_time_cal_qtr q

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;

Line 1651: from fii_time_cal_period p, fii_time_cal_qtr q

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;

Line 1660: from fii_time_cal_period p, fii_time_cal_qtr q

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