DBA Data[Home] [Help]

APPS.HRI_TIME_STRUCTURE_C dependencies on HRI_TIME_ENT_YEAR

Line 256: HRI_time_ent_year y

252: from
253: HRI_time_ent_period
254: ) m,
255: HRI_time_ent_qtr q,
256: HRI_time_ent_year y
257: WHERE
258: d.ent_period_id = m.ent_period_id
259: AND m.ent_qtr_id = q.ent_qtr_id
260: AND q.ent_year_id = y.ent_year_id; */

Line 300: from HRI_time_ent_year

296: , end_date
297: bulk collect into
298: l_ent_year_id_tbl
299: , l_ent_year_date_tbl
300: from HRI_time_ent_year
301: where end_date < g_unassigned_day;
302:
303: -- Loop for each day defined in the calendar
304: FOR d IN calendar_days LOOP