APPS.POA_DBI_CALENDAR_PKG dependencies on FII_TIME_ENT_PERIOD

Line 65: from fii_time_ent_period p, fii_time_ent_qtr q

61: if(period_type = 'MTD') then
62:
63: select p.sequence, q.ent_year_id
64: into l_curr_period, l_curr_year
65: from fii_time_ent_period p, fii_time_ent_qtr q
66: where p.ent_qtr_id=q.ent_qtr_id
67: and as_of_date between p.start_date and p.end_date;
68:
69: select start_date

Line 72: from fii_time_ent_period p, fii_time_ent_qtr q

68:
69: select start_date
70: into l_date
71: from (select p.start_date
72: from fii_time_ent_period p, fii_time_ent_qtr q
73: where p.ent_qtr_id=q.ent_qtr_id
74: and ((p.sequence>=l_curr_period+1 and q.ent_year_id=l_curr_year-1)
75: or (p.sequence>=1 and q.ent_year_id=l_curr_year))
76: order by p.start_date)