DBA Data[Home] [Help]

APPS.PJI_TIME_C dependencies on PJI_TIME_WEEK

Line 217: -- DELETE FROM PJI_TIME_WEEK WHERE start_date <= l_to_date AND end_date >= l_from_date;

213: l_period_num := get_period_num(l_week_num);
214: l_year_num := TO_CHAR(l_week-g_week_offset,'iyyy');
215: l_week_row := 0;
216:
217: -- DELETE FROM PJI_TIME_WEEK WHERE start_date <= l_to_date AND end_date >= l_from_date;
218:
219: WHILE l_week <= l_to_date LOOP
220:
221: INSERT INTO pji_time_week

Line 221: INSERT INTO pji_time_week

217: -- DELETE FROM PJI_TIME_WEEK WHERE start_date <= l_to_date AND end_date >= l_from_date;
218:
219: WHILE l_week <= l_to_date LOOP
220:
221: INSERT INTO pji_time_week
222: (week_id,
223: period445_id,
224: SEQUENCE,
225: NAME,