APPS.HRI_TIME_C dependencies on HRI_TIME_YEAR445

Line 1371: -- delete from HRI_TIME_YEAR445 where start_date <= l_to_date and end_date >= l_from_date;

1367:
1368: l_year_row := 0;
1369:
1370: -- Bug 5624487
1371: -- delete from HRI_TIME_YEAR445 where start_date <= l_to_date and end_date >= l_from_date;
1372: delete from HRI_TIME_YEAR445
1373: where start_date <= l_to_date and end_date >= l_from_date
1374: or end_date >= g_unassigned_day;
1375:

Line 1372: delete from HRI_TIME_YEAR445

1368: l_year_row := 0;
1369:
1370: -- Bug 5624487
1371: -- delete from HRI_TIME_YEAR445 where start_date <= l_to_date and end_date >= l_from_date;
1372: delete from HRI_TIME_YEAR445
1373: where start_date <= l_to_date and end_date >= l_from_date
1374: or end_date >= g_unassigned_day;
1375:
1376: -- ----------------------

Line 1385: insert into HRI_time_year445

1381: -- while l_year <= l_to_date loop
1382: while l_year <= l_to_date or l_year_end = g_unassigned_day loop
1383:
1384: -- Bug 5624487
1385: insert into HRI_time_year445
1386: (year445_id,
1387: name,
1388: start_date,
1389: end_date,

Line 2724: truncate_table('HRI_TIME_YEAR445');

2720: truncate_table('HRI_TIME_QTR');
2721: truncate_table('HRI_TIME_YEAR');
2722: truncate_table('HRI_TIME_WEEK');
2723: truncate_table('HRI_TIME_P445');
2724: truncate_table('HRI_TIME_YEAR445');
2725: truncate_table('HRI_TIME_ENT_PERIOD');
2726: truncate_table('HRI_TIME_ENT_QTR');
2727: truncate_table('HRI_TIME_ENT_YEAR');
2728: truncate_table('HRI_TIME_CAL_NAME');

Line 3098: gather_table_stats('HRI_TIME_YEAR445');

3094: if g_debug_flag = 'Y' then
3095: HRI_util.put_line('Gathered statistics for Quarter Level');
3096: end if;
3097:
3098: gather_table_stats('HRI_TIME_YEAR445');
3099:
3100: if g_debug_flag = 'Y' then
3101: HRI_util.put_line('Gathered statistics for Period 445 Level');
3102: end if;

Line 3116: truncate_table('HRI_TIME_YEAR445');

3112: else
3113:
3114: truncate_table('HRI_TIME_WEEK');
3115: truncate_table('HRI_TIME_P445');
3116: truncate_table('HRI_TIME_YEAR445');
3117: truncate_table('HRI_TIME_ENT_PERIOD');
3118: truncate_table('HRI_TIME_ENT_QTR');
3119: truncate_table('HRI_TIME_ENT_YEAR');
3120: truncate_table('HRI_TIME_CAL_PERIOD');