APPS.BIL_BI_UTIL_PKG dependencies on FII_TIME_P445

Line 1692: FROM fii_time_week w, fii_time_p445 p

1688: IF (p_period_type = 'FII_TIME_WEEK') THEN
1689:
1690: SELECT l_prev_date-w.start_date, w.sequence, p.year445_id
1691: INTO l_timespan, l_sequence, l_year
1692: FROM fii_time_week w, fii_time_p445 p
1693: WHERE w.period445_id=p.period445_id
1694: AND l_prev_date BETWEEN w.start_date AND w.end_date;
1695:
1696: IF p_comp_type='SEQUENTIAL' THEN

Line 1703: FROM fii_time_week w, fii_time_p445 p

1699: l_year:=l_year-1;
1700:
1701: SELECT MAX(w.sequence)
1702: INTO l_sequence
1703: FROM fii_time_week w, fii_time_p445 p
1704: WHERE w.period445_id=p.period445_id
1705: AND p.year445_id=l_year;
1706: else
1707:

Line 1717: FROM fii_time_week w, fii_time_p445 p

1713: END IF;
1714:
1715: SELECT w.week_id, w.start_date+l_timespan
1716: INTO l_prior_prior_time_id, l_prior_prior_date
1717: FROM fii_time_week w, fii_time_p445 p
1718: WHERE w.period445_id=p.period445_id
1719: AND w.sequence=l_sequence
1720: AND p.year445_id=l_year;
1721: