APPS.HRI_TIME_C dependencies on HRI_TIME_P445

Line 1229: -- delete from HRI_TIME_P445 where start_date <= l_to_date and end_date >= l_from_date;

1225: l_year_num := to_char(l_period-g_week_offset,'iyyy');
1226: l_period_row := 0;
1227:
1228: -- Bug 5624487
1229: -- delete from HRI_TIME_P445 where start_date <= l_to_date and end_date >= l_from_date;
1230: delete from HRI_TIME_P445
1231: where start_date <= l_to_date and end_date >= l_from_date
1232: or end_date >= g_unassigned_day;
1233:

Line 1230: delete from HRI_TIME_P445

1226: l_period_row := 0;
1227:
1228: -- Bug 5624487
1229: -- delete from HRI_TIME_P445 where start_date <= l_to_date and end_date >= l_from_date;
1230: delete from HRI_TIME_P445
1231: where start_date <= l_to_date and end_date >= l_from_date
1232: or end_date >= g_unassigned_day;
1233:
1234: -- ----------------------

Line 1243: insert into HRI_time_p445

1239: -- while l_period <= l_to_date loop
1240: while l_period <= l_to_date or l_period_end = g_unassigned_day loop
1241:
1242: -- Bug 5624487
1243: insert into HRI_time_p445
1244: (period445_id,
1245: year445_id,
1246: sequence,
1247: name,

Line 2723: truncate_table('HRI_TIME_P445');

2719: truncate_table('HRI_TIME_MONTH');
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');

Line 3115: truncate_table('HRI_TIME_P445');

3111:
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');