APPS.FII_TIME_STRUCTURE_C dependencies on FII_TIME_DAY

Line 205: -- *** All columns can be found in fii_time_day. Should we change to select all

201: -- Cursor to retrieve all days defined in the calendar
202: -- Bug 5624487
203: CURSOR calendar_days IS
204: -- *** Why do we need next_ent_period_start_date and next_ent_period_end_date?
205: -- *** All columns can be found in fii_time_day. Should we change to select all
206: -- these columns from fii_time_day?
207: SELECT
208: report_date,
209: week_start_date,

Line 206: -- these columns from fii_time_day?

202: -- Bug 5624487
203: CURSOR calendar_days IS
204: -- *** Why do we need next_ent_period_start_date and next_ent_period_end_date?
205: -- *** All columns can be found in fii_time_day. Should we change to select all
206: -- these columns from fii_time_day?
207: SELECT
208: report_date,
209: week_start_date,
210: week_end_date,

Line 223: fii_time_day

219: ent_period_id,
220: ent_qtr_id,
221: ent_year_id
222: FROM
223: fii_time_day
224: where report_date <> g_unassigned_day;
225: /* SELECT
226: d.report_date,
227: d.week_start_date,

Line 243: fii_time_day d,

239: m.ent_year_id,
240: m.next_start_date next_ent_period_start_date,
241: m.next_end_date next_ent_period_end_date
242: FROM
243: fii_time_day d,
244: ( select
245: start_date
246: , end_date
247: , ent_period_id

Line 265: FROM fii_time_day

261:
262: -- Bug 5624487
263: CURSOR calendar_max_day IS
264: SELECT max(report_date) max_report_date
265: FROM fii_time_day
266: where report_date <> g_unassigned_day;
267:
268: l_row_cnt number := 0;
269: