eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_TIME_ROLLING_PKG dependencies on HRI_TIME_ROLLING_OFFSETS

Line 17: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

13: BEGIN
14:
15: l_user := FND_GLOBAL.USER_ID;
16:
17: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
18: values ('HRI_ROLLING_WEEK' ,'YEARLY', 0, -6, 0, sysdate, l_user, sysdate, l_user, l_user);
19: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
20: values ('HRI_ROLLING_WEEK' ,'YEARLY', -7, -6,1, sysdate, l_user, sysdate, l_user, l_user);
21: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 19: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

15: l_user := FND_GLOBAL.USER_ID;
16:
17: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
18: values ('HRI_ROLLING_WEEK' ,'YEARLY', 0, -6, 0, sysdate, l_user, sysdate, l_user, l_user);
19: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
20: values ('HRI_ROLLING_WEEK' ,'YEARLY', -7, -6,1, sysdate, l_user, sysdate, l_user, l_user);
21: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
22: values ('HRI_ROLLING_WEEK' ,'YEARLY', -14, -6, 2, sysdate, l_user, sysdate, l_user, l_user);
23: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 21: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

17: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
18: values ('HRI_ROLLING_WEEK' ,'YEARLY', 0, -6, 0, sysdate, l_user, sysdate, l_user, l_user);
19: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
20: values ('HRI_ROLLING_WEEK' ,'YEARLY', -7, -6,1, sysdate, l_user, sysdate, l_user, l_user);
21: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
22: values ('HRI_ROLLING_WEEK' ,'YEARLY', -14, -6, 2, sysdate, l_user, sysdate, l_user, l_user);
23: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
24: values ('HRI_ROLLING_WEEK' ,'YEARLY', -21, -6 , 3, sysdate, l_user, sysdate, l_user, l_user);
25: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 23: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

19: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
20: values ('HRI_ROLLING_WEEK' ,'YEARLY', -7, -6,1, sysdate, l_user, sysdate, l_user, l_user);
21: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
22: values ('HRI_ROLLING_WEEK' ,'YEARLY', -14, -6, 2, sysdate, l_user, sysdate, l_user, l_user);
23: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
24: values ('HRI_ROLLING_WEEK' ,'YEARLY', -21, -6 , 3, sysdate, l_user, sysdate, l_user, l_user);
25: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
26: values ('HRI_ROLLING_WEEK' ,'YEARLY', -28 , -6 , 4, sysdate, l_user, sysdate, l_user, l_user);
27: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 25: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

21: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
22: values ('HRI_ROLLING_WEEK' ,'YEARLY', -14, -6, 2, sysdate, l_user, sysdate, l_user, l_user);
23: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
24: values ('HRI_ROLLING_WEEK' ,'YEARLY', -21, -6 , 3, sysdate, l_user, sysdate, l_user, l_user);
25: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
26: values ('HRI_ROLLING_WEEK' ,'YEARLY', -28 , -6 , 4, sysdate, l_user, sysdate, l_user, l_user);
27: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
28: values ('HRI_ROLLING_WEEK' ,'YEARLY', -35, -6 , 5, sysdate, l_user, sysdate, l_user, l_user);
29: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 27: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

23: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
24: values ('HRI_ROLLING_WEEK' ,'YEARLY', -21, -6 , 3, sysdate, l_user, sysdate, l_user, l_user);
25: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
26: values ('HRI_ROLLING_WEEK' ,'YEARLY', -28 , -6 , 4, sysdate, l_user, sysdate, l_user, l_user);
27: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
28: values ('HRI_ROLLING_WEEK' ,'YEARLY', -35, -6 , 5, sysdate, l_user, sysdate, l_user, l_user);
29: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
30: values ('HRI_ROLLING_WEEK' ,'YEARLY', -42, -6 , 6, sysdate, l_user, sysdate, l_user, l_user);
31: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 29: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

25: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
26: values ('HRI_ROLLING_WEEK' ,'YEARLY', -28 , -6 , 4, sysdate, l_user, sysdate, l_user, l_user);
27: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
28: values ('HRI_ROLLING_WEEK' ,'YEARLY', -35, -6 , 5, sysdate, l_user, sysdate, l_user, l_user);
29: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
30: values ('HRI_ROLLING_WEEK' ,'YEARLY', -42, -6 , 6, sysdate, l_user, sysdate, l_user, l_user);
31: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
32: values ('HRI_ROLLING_WEEK' ,'YEARLY', -49, -6 , 7, sysdate, l_user, sysdate, l_user, l_user);
33: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 31: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

27: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
28: values ('HRI_ROLLING_WEEK' ,'YEARLY', -35, -6 , 5, sysdate, l_user, sysdate, l_user, l_user);
29: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
30: values ('HRI_ROLLING_WEEK' ,'YEARLY', -42, -6 , 6, sysdate, l_user, sysdate, l_user, l_user);
31: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
32: values ('HRI_ROLLING_WEEK' ,'YEARLY', -49, -6 , 7, sysdate, l_user, sysdate, l_user, l_user);
33: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
34: values ('HRI_ROLLING_WEEK' ,'YEARLY', -56, -6 , 8 , sysdate, l_user, sysdate, l_user, l_user);
35: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 33: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

29: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
30: values ('HRI_ROLLING_WEEK' ,'YEARLY', -42, -6 , 6, sysdate, l_user, sysdate, l_user, l_user);
31: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
32: values ('HRI_ROLLING_WEEK' ,'YEARLY', -49, -6 , 7, sysdate, l_user, sysdate, l_user, l_user);
33: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
34: values ('HRI_ROLLING_WEEK' ,'YEARLY', -56, -6 , 8 , sysdate, l_user, sysdate, l_user, l_user);
35: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
36: values ('HRI_ROLLING_WEEK' ,'YEARLY', -63, -6 , 9, sysdate, l_user, sysdate, l_user, l_user);
37: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 35: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

31: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
32: values ('HRI_ROLLING_WEEK' ,'YEARLY', -49, -6 , 7, sysdate, l_user, sysdate, l_user, l_user);
33: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
34: values ('HRI_ROLLING_WEEK' ,'YEARLY', -56, -6 , 8 , sysdate, l_user, sysdate, l_user, l_user);
35: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
36: values ('HRI_ROLLING_WEEK' ,'YEARLY', -63, -6 , 9, sysdate, l_user, sysdate, l_user, l_user);
37: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
38: values ('HRI_ROLLING_WEEK' ,'YEARLY', -70, -6 , 10, sysdate, l_user, sysdate, l_user, l_user);
39: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 37: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

33: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
34: values ('HRI_ROLLING_WEEK' ,'YEARLY', -56, -6 , 8 , sysdate, l_user, sysdate, l_user, l_user);
35: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
36: values ('HRI_ROLLING_WEEK' ,'YEARLY', -63, -6 , 9, sysdate, l_user, sysdate, l_user, l_user);
37: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
38: values ('HRI_ROLLING_WEEK' ,'YEARLY', -70, -6 , 10, sysdate, l_user, sysdate, l_user, l_user);
39: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
40: values ('HRI_ROLLING_WEEK' ,'YEARLY', -77, -6 , 11, sysdate, l_user, sysdate, l_user, l_user);
41: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 39: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

35: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
36: values ('HRI_ROLLING_WEEK' ,'YEARLY', -63, -6 , 9, sysdate, l_user, sysdate, l_user, l_user);
37: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
38: values ('HRI_ROLLING_WEEK' ,'YEARLY', -70, -6 , 10, sysdate, l_user, sysdate, l_user, l_user);
39: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
40: values ('HRI_ROLLING_WEEK' ,'YEARLY', -77, -6 , 11, sysdate, l_user, sysdate, l_user, l_user);
41: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
42: values ('HRI_ROLLING_WEEK' ,'YEARLY', -84, -6 , 12, sysdate, l_user, sysdate, l_user, l_user);
43: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 41: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

37: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
38: values ('HRI_ROLLING_WEEK' ,'YEARLY', -70, -6 , 10, sysdate, l_user, sysdate, l_user, l_user);
39: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
40: values ('HRI_ROLLING_WEEK' ,'YEARLY', -77, -6 , 11, sysdate, l_user, sysdate, l_user, l_user);
41: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
42: values ('HRI_ROLLING_WEEK' ,'YEARLY', -84, -6 , 12, sysdate, l_user, sysdate, l_user, l_user);
43: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
44: values ('HRI_ROLLING_MONTH' ,'YEARLY', 0 , -29, 0, sysdate, l_user, sysdate, l_user, l_user);
45: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 43: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

39: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
40: values ('HRI_ROLLING_WEEK' ,'YEARLY', -77, -6 , 11, sysdate, l_user, sysdate, l_user, l_user);
41: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
42: values ('HRI_ROLLING_WEEK' ,'YEARLY', -84, -6 , 12, sysdate, l_user, sysdate, l_user, l_user);
43: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
44: values ('HRI_ROLLING_MONTH' ,'YEARLY', 0 , -29, 0, sysdate, l_user, sysdate, l_user, l_user);
45: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
46: values ('HRI_ROLLING_MONTH' ,'YEARLY', -30 ,-29, 1 , sysdate, l_user, sysdate, l_user, l_user);
47: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 45: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

41: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
42: values ('HRI_ROLLING_WEEK' ,'YEARLY', -84, -6 , 12, sysdate, l_user, sysdate, l_user, l_user);
43: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
44: values ('HRI_ROLLING_MONTH' ,'YEARLY', 0 , -29, 0, sysdate, l_user, sysdate, l_user, l_user);
45: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
46: values ('HRI_ROLLING_MONTH' ,'YEARLY', -30 ,-29, 1 , sysdate, l_user, sysdate, l_user, l_user);
47: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
48: values ('HRI_ROLLING_MONTH' ,'YEARLY', -60 ,-29, 2 , sysdate, l_user, sysdate, l_user, l_user);
49: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 47: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

43: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
44: values ('HRI_ROLLING_MONTH' ,'YEARLY', 0 , -29, 0, sysdate, l_user, sysdate, l_user, l_user);
45: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
46: values ('HRI_ROLLING_MONTH' ,'YEARLY', -30 ,-29, 1 , sysdate, l_user, sysdate, l_user, l_user);
47: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
48: values ('HRI_ROLLING_MONTH' ,'YEARLY', -60 ,-29, 2 , sysdate, l_user, sysdate, l_user, l_user);
49: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
50: values ('HRI_ROLLING_MONTH' ,'YEARLY', -90 ,-29, 3 , sysdate, l_user, sysdate, l_user, l_user);
51: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 49: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

45: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
46: values ('HRI_ROLLING_MONTH' ,'YEARLY', -30 ,-29, 1 , sysdate, l_user, sysdate, l_user, l_user);
47: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
48: values ('HRI_ROLLING_MONTH' ,'YEARLY', -60 ,-29, 2 , sysdate, l_user, sysdate, l_user, l_user);
49: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
50: values ('HRI_ROLLING_MONTH' ,'YEARLY', -90 ,-29, 3 , sysdate, l_user, sysdate, l_user, l_user);
51: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
52: values ('HRI_ROLLING_MONTH' ,'YEARLY', -120 ,-29, 4 , sysdate, l_user, sysdate, l_user, l_user);
53: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 51: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

47: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
48: values ('HRI_ROLLING_MONTH' ,'YEARLY', -60 ,-29, 2 , sysdate, l_user, sysdate, l_user, l_user);
49: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
50: values ('HRI_ROLLING_MONTH' ,'YEARLY', -90 ,-29, 3 , sysdate, l_user, sysdate, l_user, l_user);
51: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
52: values ('HRI_ROLLING_MONTH' ,'YEARLY', -120 ,-29, 4 , sysdate, l_user, sysdate, l_user, l_user);
53: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
54: values ('HRI_ROLLING_MONTH' ,'YEARLY', -150 ,-29, 5 , sysdate, l_user, sysdate, l_user, l_user);
55: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 53: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

49: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
50: values ('HRI_ROLLING_MONTH' ,'YEARLY', -90 ,-29, 3 , sysdate, l_user, sysdate, l_user, l_user);
51: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
52: values ('HRI_ROLLING_MONTH' ,'YEARLY', -120 ,-29, 4 , sysdate, l_user, sysdate, l_user, l_user);
53: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
54: values ('HRI_ROLLING_MONTH' ,'YEARLY', -150 ,-29, 5 , sysdate, l_user, sysdate, l_user, l_user);
55: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
56: values ('HRI_ROLLING_MONTH' ,'YEARLY', -180 ,-29, 6 , sysdate, l_user, sysdate, l_user, l_user);
57: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 55: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

51: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
52: values ('HRI_ROLLING_MONTH' ,'YEARLY', -120 ,-29, 4 , sysdate, l_user, sysdate, l_user, l_user);
53: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
54: values ('HRI_ROLLING_MONTH' ,'YEARLY', -150 ,-29, 5 , sysdate, l_user, sysdate, l_user, l_user);
55: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
56: values ('HRI_ROLLING_MONTH' ,'YEARLY', -180 ,-29, 6 , sysdate, l_user, sysdate, l_user, l_user);
57: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
58: values ('HRI_ROLLING_MONTH' ,'YEARLY', -210 ,-29, 7 , sysdate, l_user, sysdate, l_user, l_user);
59: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 57: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

53: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
54: values ('HRI_ROLLING_MONTH' ,'YEARLY', -150 ,-29, 5 , sysdate, l_user, sysdate, l_user, l_user);
55: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
56: values ('HRI_ROLLING_MONTH' ,'YEARLY', -180 ,-29, 6 , sysdate, l_user, sysdate, l_user, l_user);
57: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
58: values ('HRI_ROLLING_MONTH' ,'YEARLY', -210 ,-29, 7 , sysdate, l_user, sysdate, l_user, l_user);
59: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
60: values ('HRI_ROLLING_MONTH' ,'YEARLY', -240 ,-29, 8 , sysdate, l_user, sysdate, l_user, l_user);
61: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 59: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

55: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
56: values ('HRI_ROLLING_MONTH' ,'YEARLY', -180 ,-29, 6 , sysdate, l_user, sysdate, l_user, l_user);
57: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
58: values ('HRI_ROLLING_MONTH' ,'YEARLY', -210 ,-29, 7 , sysdate, l_user, sysdate, l_user, l_user);
59: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
60: values ('HRI_ROLLING_MONTH' ,'YEARLY', -240 ,-29, 8 , sysdate, l_user, sysdate, l_user, l_user);
61: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
62: values ('HRI_ROLLING_MONTH' ,'YEARLY', -270 ,-29, 9 , sysdate, l_user, sysdate, l_user, l_user);
63: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 61: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

57: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
58: values ('HRI_ROLLING_MONTH' ,'YEARLY', -210 ,-29, 7 , sysdate, l_user, sysdate, l_user, l_user);
59: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
60: values ('HRI_ROLLING_MONTH' ,'YEARLY', -240 ,-29, 8 , sysdate, l_user, sysdate, l_user, l_user);
61: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
62: values ('HRI_ROLLING_MONTH' ,'YEARLY', -270 ,-29, 9 , sysdate, l_user, sysdate, l_user, l_user);
63: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
64: values ('HRI_ROLLING_MONTH' ,'YEARLY', -300 ,-29, 10 , sysdate, l_user, sysdate, l_user, l_user);
65: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 63: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

59: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
60: values ('HRI_ROLLING_MONTH' ,'YEARLY', -240 ,-29, 8 , sysdate, l_user, sysdate, l_user, l_user);
61: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
62: values ('HRI_ROLLING_MONTH' ,'YEARLY', -270 ,-29, 9 , sysdate, l_user, sysdate, l_user, l_user);
63: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
64: values ('HRI_ROLLING_MONTH' ,'YEARLY', -300 ,-29, 10 , sysdate, l_user, sysdate, l_user, l_user);
65: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
66: values ('HRI_ROLLING_MONTH' ,'YEARLY', -330 ,-29, 11 , sysdate, l_user, sysdate, l_user, l_user);
67: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 65: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

61: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
62: values ('HRI_ROLLING_MONTH' ,'YEARLY', -270 ,-29, 9 , sysdate, l_user, sysdate, l_user, l_user);
63: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
64: values ('HRI_ROLLING_MONTH' ,'YEARLY', -300 ,-29, 10 , sysdate, l_user, sysdate, l_user, l_user);
65: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
66: values ('HRI_ROLLING_MONTH' ,'YEARLY', -330 ,-29, 11 , sysdate, l_user, sysdate, l_user, l_user);
67: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
68: values ('HRI_ROLLING_QTR' ,'YEARLY', 0 ,-89, 0 , sysdate, l_user, sysdate, l_user, l_user);
69: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 67: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

63: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
64: values ('HRI_ROLLING_MONTH' ,'YEARLY', -300 ,-29, 10 , sysdate, l_user, sysdate, l_user, l_user);
65: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
66: values ('HRI_ROLLING_MONTH' ,'YEARLY', -330 ,-29, 11 , sysdate, l_user, sysdate, l_user, l_user);
67: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
68: values ('HRI_ROLLING_QTR' ,'YEARLY', 0 ,-89, 0 , sysdate, l_user, sysdate, l_user, l_user);
69: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
70: values ('HRI_ROLLING_QTR' ,'YEARLY', -90 ,-89, 1 , sysdate, l_user, sysdate, l_user, l_user);
71: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 69: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

65: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
66: values ('HRI_ROLLING_MONTH' ,'YEARLY', -330 ,-29, 11 , sysdate, l_user, sysdate, l_user, l_user);
67: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
68: values ('HRI_ROLLING_QTR' ,'YEARLY', 0 ,-89, 0 , sysdate, l_user, sysdate, l_user, l_user);
69: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
70: values ('HRI_ROLLING_QTR' ,'YEARLY', -90 ,-89, 1 , sysdate, l_user, sysdate, l_user, l_user);
71: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
72: values ('HRI_ROLLING_QTR' ,'YEARLY', -180 ,-89, 2 , sysdate, l_user, sysdate, l_user, l_user);
73: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 71: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

67: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
68: values ('HRI_ROLLING_QTR' ,'YEARLY', 0 ,-89, 0 , sysdate, l_user, sysdate, l_user, l_user);
69: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
70: values ('HRI_ROLLING_QTR' ,'YEARLY', -90 ,-89, 1 , sysdate, l_user, sysdate, l_user, l_user);
71: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
72: values ('HRI_ROLLING_QTR' ,'YEARLY', -180 ,-89, 2 , sysdate, l_user, sysdate, l_user, l_user);
73: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
74: values ('HRI_ROLLING_QTR' ,'YEARLY', -270 ,-89, 3 , sysdate, l_user, sysdate, l_user, l_user);
75: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 73: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

69: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
70: values ('HRI_ROLLING_QTR' ,'YEARLY', -90 ,-89, 1 , sysdate, l_user, sysdate, l_user, l_user);
71: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
72: values ('HRI_ROLLING_QTR' ,'YEARLY', -180 ,-89, 2 , sysdate, l_user, sysdate, l_user, l_user);
73: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
74: values ('HRI_ROLLING_QTR' ,'YEARLY', -270 ,-89, 3 , sysdate, l_user, sysdate, l_user, l_user);
75: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
76: values ('HRI_ROLLING_YEAR' ,'YEARLY', 0 ,-364, 0 , sysdate, l_user, sysdate, l_user, l_user);
77: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 75: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

71: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
72: values ('HRI_ROLLING_QTR' ,'YEARLY', -180 ,-89, 2 , sysdate, l_user, sysdate, l_user, l_user);
73: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
74: values ('HRI_ROLLING_QTR' ,'YEARLY', -270 ,-89, 3 , sysdate, l_user, sysdate, l_user, l_user);
75: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
76: values ('HRI_ROLLING_YEAR' ,'YEARLY', 0 ,-364, 0 , sysdate, l_user, sysdate, l_user, l_user);
77: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
78: values ('HRI_ROLLING_YEAR' ,'YEARLY', -365 ,-364, 1 , sysdate, l_user, sysdate, l_user, l_user);
79: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 77: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

73: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
74: values ('HRI_ROLLING_QTR' ,'YEARLY', -270 ,-89, 3 , sysdate, l_user, sysdate, l_user, l_user);
75: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
76: values ('HRI_ROLLING_YEAR' ,'YEARLY', 0 ,-364, 0 , sysdate, l_user, sysdate, l_user, l_user);
77: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
78: values ('HRI_ROLLING_YEAR' ,'YEARLY', -365 ,-364, 1 , sysdate, l_user, sysdate, l_user, l_user);
79: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
80: values ('HRI_ROLLING_YEAR' ,'YEARLY', -730 ,-364, 2 , sysdate, l_user, sysdate, l_user, l_user);
81: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 79: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

75: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
76: values ('HRI_ROLLING_YEAR' ,'YEARLY', 0 ,-364, 0 , sysdate, l_user, sysdate, l_user, l_user);
77: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
78: values ('HRI_ROLLING_YEAR' ,'YEARLY', -365 ,-364, 1 , sysdate, l_user, sysdate, l_user, l_user);
79: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
80: values ('HRI_ROLLING_YEAR' ,'YEARLY', -730 ,-364, 2 , sysdate, l_user, sysdate, l_user, l_user);
81: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
82: values ('HRI_ROLLING_YEAR' ,'YEARLY', -1095 ,-364,3 , sysdate, l_user, sysdate, l_user, l_user);
83: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 81: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

77: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
78: values ('HRI_ROLLING_YEAR' ,'YEARLY', -365 ,-364, 1 , sysdate, l_user, sysdate, l_user, l_user);
79: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
80: values ('HRI_ROLLING_YEAR' ,'YEARLY', -730 ,-364, 2 , sysdate, l_user, sysdate, l_user, l_user);
81: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
82: values ('HRI_ROLLING_YEAR' ,'YEARLY', -1095 ,-364,3 , sysdate, l_user, sysdate, l_user, l_user);
83: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
84: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', 0, -6 , 0 , sysdate, l_user, sysdate, l_user, l_user);
85: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 83: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

79: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
80: values ('HRI_ROLLING_YEAR' ,'YEARLY', -730 ,-364, 2 , sysdate, l_user, sysdate, l_user, l_user);
81: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
82: values ('HRI_ROLLING_YEAR' ,'YEARLY', -1095 ,-364,3 , sysdate, l_user, sysdate, l_user, l_user);
83: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
84: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', 0, -6 , 0 , sysdate, l_user, sysdate, l_user, l_user);
85: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
86: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -7, -6 , 1 , sysdate, l_user, sysdate, l_user, l_user);
87: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 85: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

81: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
82: values ('HRI_ROLLING_YEAR' ,'YEARLY', -1095 ,-364,3 , sysdate, l_user, sysdate, l_user, l_user);
83: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
84: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', 0, -6 , 0 , sysdate, l_user, sysdate, l_user, l_user);
85: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
86: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -7, -6 , 1 , sysdate, l_user, sysdate, l_user, l_user);
87: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
88: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -14, -6 , 2 , sysdate, l_user, sysdate, l_user, l_user);
89: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 87: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

83: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
84: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', 0, -6 , 0 , sysdate, l_user, sysdate, l_user, l_user);
85: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
86: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -7, -6 , 1 , sysdate, l_user, sysdate, l_user, l_user);
87: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
88: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -14, -6 , 2 , sysdate, l_user, sysdate, l_user, l_user);
89: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
90: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -21 , -6 , 3 , sysdate, l_user, sysdate, l_user, l_user);
91: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 89: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

85: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
86: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -7, -6 , 1 , sysdate, l_user, sysdate, l_user, l_user);
87: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
88: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -14, -6 , 2 , sysdate, l_user, sysdate, l_user, l_user);
89: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
90: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -21 , -6 , 3 , sysdate, l_user, sysdate, l_user, l_user);
91: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
92: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -28 , -6 , 4 , sysdate, l_user, sysdate, l_user, l_user);
93: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 91: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

87: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
88: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -14, -6 , 2 , sysdate, l_user, sysdate, l_user, l_user);
89: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
90: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -21 , -6 , 3 , sysdate, l_user, sysdate, l_user, l_user);
91: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
92: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -28 , -6 , 4 , sysdate, l_user, sysdate, l_user, l_user);
93: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
94: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -35 , -6 , 5 , sysdate, l_user, sysdate, l_user, l_user);
95: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 93: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

89: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
90: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -21 , -6 , 3 , sysdate, l_user, sysdate, l_user, l_user);
91: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
92: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -28 , -6 , 4 , sysdate, l_user, sysdate, l_user, l_user);
93: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
94: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -35 , -6 , 5 , sysdate, l_user, sysdate, l_user, l_user);
95: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
96: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -42 , -6 , 6 , sysdate, l_user, sysdate, l_user, l_user);
97: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 95: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

91: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
92: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -28 , -6 , 4 , sysdate, l_user, sysdate, l_user, l_user);
93: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
94: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -35 , -6 , 5 , sysdate, l_user, sysdate, l_user, l_user);
95: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
96: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -42 , -6 , 6 , sysdate, l_user, sysdate, l_user, l_user);
97: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
98: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -49 , -6 , 7 , sysdate, l_user, sysdate, l_user, l_user);
99: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 97: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

93: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
94: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -35 , -6 , 5 , sysdate, l_user, sysdate, l_user, l_user);
95: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
96: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -42 , -6 , 6 , sysdate, l_user, sysdate, l_user, l_user);
97: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
98: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -49 , -6 , 7 , sysdate, l_user, sysdate, l_user, l_user);
99: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
100: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -56 , -6 , 8 , sysdate, l_user, sysdate, l_user, l_user);
101: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 99: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

95: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
96: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -42 , -6 , 6 , sysdate, l_user, sysdate, l_user, l_user);
97: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
98: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -49 , -6 , 7 , sysdate, l_user, sysdate, l_user, l_user);
99: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
100: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -56 , -6 , 8 , sysdate, l_user, sysdate, l_user, l_user);
101: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
102: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -63 , -6 , 9 , sysdate, l_user, sysdate, l_user, l_user);
103: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 101: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

97: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
98: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -49 , -6 , 7 , sysdate, l_user, sysdate, l_user, l_user);
99: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
100: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -56 , -6 , 8 , sysdate, l_user, sysdate, l_user, l_user);
101: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
102: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -63 , -6 , 9 , sysdate, l_user, sysdate, l_user, l_user);
103: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
104: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -70 , -6 , 10 , sysdate, l_user, sysdate, l_user, l_user);
105: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 103: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

99: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
100: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -56 , -6 , 8 , sysdate, l_user, sysdate, l_user, l_user);
101: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
102: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -63 , -6 , 9 , sysdate, l_user, sysdate, l_user, l_user);
103: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
104: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -70 , -6 , 10 , sysdate, l_user, sysdate, l_user, l_user);
105: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
106: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -77 , -6 , 11 , sysdate, l_user, sysdate, l_user, l_user);
107: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 105: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

101: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
102: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -63 , -6 , 9 , sysdate, l_user, sysdate, l_user, l_user);
103: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
104: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -70 , -6 , 10 , sysdate, l_user, sysdate, l_user, l_user);
105: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
106: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -77 , -6 , 11 , sysdate, l_user, sysdate, l_user, l_user);
107: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
108: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -84 , -6 , 12 , sysdate, l_user, sysdate, l_user, l_user);
109: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 107: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

103: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
104: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -70 , -6 , 10 , sysdate, l_user, sysdate, l_user, l_user);
105: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
106: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -77 , -6 , 11 , sysdate, l_user, sysdate, l_user, l_user);
107: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
108: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -84 , -6 , 12 , sysdate, l_user, sysdate, l_user, l_user);
109: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
110: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', 0 ,-29, 0, sysdate, l_user, sysdate, l_user, l_user);
111: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 109: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

105: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
106: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -77 , -6 , 11 , sysdate, l_user, sysdate, l_user, l_user);
107: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
108: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -84 , -6 , 12 , sysdate, l_user, sysdate, l_user, l_user);
109: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
110: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', 0 ,-29, 0, sysdate, l_user, sysdate, l_user, l_user);
111: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
112: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -30 ,-29, 1, sysdate, l_user, sysdate, l_user, l_user);
113: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 111: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

107: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
108: values ('HRI_ROLLING_WEEK' ,'SEQUENTIAL', -84 , -6 , 12 , sysdate, l_user, sysdate, l_user, l_user);
109: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
110: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', 0 ,-29, 0, sysdate, l_user, sysdate, l_user, l_user);
111: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
112: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -30 ,-29, 1, sysdate, l_user, sysdate, l_user, l_user);
113: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
114: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -60 ,-29, 2 , sysdate, l_user, sysdate, l_user, l_user);
115: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 113: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

109: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
110: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', 0 ,-29, 0, sysdate, l_user, sysdate, l_user, l_user);
111: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
112: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -30 ,-29, 1, sysdate, l_user, sysdate, l_user, l_user);
113: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
114: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -60 ,-29, 2 , sysdate, l_user, sysdate, l_user, l_user);
115: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
116: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -90 ,-29, 3 , sysdate, l_user, sysdate, l_user, l_user);
117: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 115: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

111: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
112: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -30 ,-29, 1, sysdate, l_user, sysdate, l_user, l_user);
113: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
114: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -60 ,-29, 2 , sysdate, l_user, sysdate, l_user, l_user);
115: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
116: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -90 ,-29, 3 , sysdate, l_user, sysdate, l_user, l_user);
117: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
118: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -120 ,-29, 4 , sysdate, l_user, sysdate, l_user, l_user);
119: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 117: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

113: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
114: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -60 ,-29, 2 , sysdate, l_user, sysdate, l_user, l_user);
115: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
116: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -90 ,-29, 3 , sysdate, l_user, sysdate, l_user, l_user);
117: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
118: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -120 ,-29, 4 , sysdate, l_user, sysdate, l_user, l_user);
119: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
120: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -150 ,-29, 5 , sysdate, l_user, sysdate, l_user, l_user);
121: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 119: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

115: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
116: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -90 ,-29, 3 , sysdate, l_user, sysdate, l_user, l_user);
117: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
118: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -120 ,-29, 4 , sysdate, l_user, sysdate, l_user, l_user);
119: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
120: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -150 ,-29, 5 , sysdate, l_user, sysdate, l_user, l_user);
121: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
122: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -180 ,-29, 6 , sysdate, l_user, sysdate, l_user, l_user);
123: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 121: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

117: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
118: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -120 ,-29, 4 , sysdate, l_user, sysdate, l_user, l_user);
119: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
120: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -150 ,-29, 5 , sysdate, l_user, sysdate, l_user, l_user);
121: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
122: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -180 ,-29, 6 , sysdate, l_user, sysdate, l_user, l_user);
123: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
124: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -210 ,-29, 7 , sysdate, l_user, sysdate, l_user, l_user);
125: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 123: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

119: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
120: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -150 ,-29, 5 , sysdate, l_user, sysdate, l_user, l_user);
121: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
122: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -180 ,-29, 6 , sysdate, l_user, sysdate, l_user, l_user);
123: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
124: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -210 ,-29, 7 , sysdate, l_user, sysdate, l_user, l_user);
125: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
126: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -240 ,-29, 8 , sysdate, l_user, sysdate, l_user, l_user);
127: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 125: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

121: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
122: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -180 ,-29, 6 , sysdate, l_user, sysdate, l_user, l_user);
123: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
124: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -210 ,-29, 7 , sysdate, l_user, sysdate, l_user, l_user);
125: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
126: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -240 ,-29, 8 , sysdate, l_user, sysdate, l_user, l_user);
127: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
128: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -270 ,-29, 9 , sysdate, l_user, sysdate, l_user, l_user);
129: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 127: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

123: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
124: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -210 ,-29, 7 , sysdate, l_user, sysdate, l_user, l_user);
125: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
126: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -240 ,-29, 8 , sysdate, l_user, sysdate, l_user, l_user);
127: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
128: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -270 ,-29, 9 , sysdate, l_user, sysdate, l_user, l_user);
129: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
130: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -300 ,-29, 10 , sysdate, l_user, sysdate, l_user, l_user);
131: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 129: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

125: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
126: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -240 ,-29, 8 , sysdate, l_user, sysdate, l_user, l_user);
127: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
128: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -270 ,-29, 9 , sysdate, l_user, sysdate, l_user, l_user);
129: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
130: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -300 ,-29, 10 , sysdate, l_user, sysdate, l_user, l_user);
131: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
132: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -330 ,-29, 11 , sysdate, l_user, sysdate, l_user, l_user);
133: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 131: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

127: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
128: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -270 ,-29, 9 , sysdate, l_user, sysdate, l_user, l_user);
129: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
130: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -300 ,-29, 10 , sysdate, l_user, sysdate, l_user, l_user);
131: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
132: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -330 ,-29, 11 , sysdate, l_user, sysdate, l_user, l_user);
133: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
134: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', 0 ,-89, 0 , sysdate, l_user, sysdate, l_user, l_user);
135: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 133: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

129: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
130: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -300 ,-29, 10 , sysdate, l_user, sysdate, l_user, l_user);
131: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
132: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -330 ,-29, 11 , sysdate, l_user, sysdate, l_user, l_user);
133: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
134: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', 0 ,-89, 0 , sysdate, l_user, sysdate, l_user, l_user);
135: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
136: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -90 ,-89, 1 , sysdate, l_user, sysdate, l_user, l_user);
137: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 135: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

131: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
132: values ('HRI_ROLLING_MONTH' ,'SEQUENTIAL', -330 ,-29, 11 , sysdate, l_user, sysdate, l_user, l_user);
133: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
134: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', 0 ,-89, 0 , sysdate, l_user, sysdate, l_user, l_user);
135: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
136: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -90 ,-89, 1 , sysdate, l_user, sysdate, l_user, l_user);
137: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
138: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -180 ,-89, 2 , sysdate, l_user, sysdate, l_user, l_user);
139: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 137: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

133: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
134: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', 0 ,-89, 0 , sysdate, l_user, sysdate, l_user, l_user);
135: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
136: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -90 ,-89, 1 , sysdate, l_user, sysdate, l_user, l_user);
137: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
138: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -180 ,-89, 2 , sysdate, l_user, sysdate, l_user, l_user);
139: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
140: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -270 ,-89, 3 , sysdate, l_user, sysdate, l_user, l_user);
141: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 139: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

135: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
136: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -90 ,-89, 1 , sysdate, l_user, sysdate, l_user, l_user);
137: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
138: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -180 ,-89, 2 , sysdate, l_user, sysdate, l_user, l_user);
139: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
140: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -270 ,-89, 3 , sysdate, l_user, sysdate, l_user, l_user);
141: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
142: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -360 ,-89, 4 , sysdate, l_user, sysdate, l_user, l_user);
143: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 141: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

137: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
138: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -180 ,-89, 2 , sysdate, l_user, sysdate, l_user, l_user);
139: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
140: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -270 ,-89, 3 , sysdate, l_user, sysdate, l_user, l_user);
141: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
142: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -360 ,-89, 4 , sysdate, l_user, sysdate, l_user, l_user);
143: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
144: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -450 ,-89, 5 , sysdate, l_user, sysdate, l_user, l_user);
145: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 143: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

139: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
140: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -270 ,-89, 3 , sysdate, l_user, sysdate, l_user, l_user);
141: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
142: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -360 ,-89, 4 , sysdate, l_user, sysdate, l_user, l_user);
143: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
144: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -450 ,-89, 5 , sysdate, l_user, sysdate, l_user, l_user);
145: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
146: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -540 ,-89,6 , sysdate, l_user, sysdate, l_user, l_user);
147: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 145: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

141: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
142: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -360 ,-89, 4 , sysdate, l_user, sysdate, l_user, l_user);
143: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
144: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -450 ,-89, 5 , sysdate, l_user, sysdate, l_user, l_user);
145: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
146: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -540 ,-89,6 , sysdate, l_user, sysdate, l_user, l_user);
147: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
148: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -630 ,-89,7 , sysdate, l_user, sysdate, l_user, l_user);
149: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 147: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

143: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
144: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -450 ,-89, 5 , sysdate, l_user, sysdate, l_user, l_user);
145: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
146: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -540 ,-89,6 , sysdate, l_user, sysdate, l_user, l_user);
147: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
148: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -630 ,-89,7 , sysdate, l_user, sysdate, l_user, l_user);
149: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
150: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', 0 ,-364,0 , sysdate, l_user, sysdate, l_user, l_user);
151: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 149: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

145: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
146: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -540 ,-89,6 , sysdate, l_user, sysdate, l_user, l_user);
147: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
148: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -630 ,-89,7 , sysdate, l_user, sysdate, l_user, l_user);
149: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
150: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', 0 ,-364,0 , sysdate, l_user, sysdate, l_user, l_user);
151: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
152: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', -365 ,-364,1 , sysdate, l_user, sysdate, l_user, l_user);
153: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 151: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

147: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
148: values ('HRI_ROLLING_QTR' ,'SEQUENTIAL', -630 ,-89,7 , sysdate, l_user, sysdate, l_user, l_user);
149: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
150: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', 0 ,-364,0 , sysdate, l_user, sysdate, l_user, l_user);
151: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
152: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', -365 ,-364,1 , sysdate, l_user, sysdate, l_user, l_user);
153: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
154: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', -730 ,-364,2 , sysdate, l_user, sysdate, l_user, l_user);
155: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

Line 153: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

149: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
150: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', 0 ,-364,0 , sysdate, l_user, sysdate, l_user, l_user);
151: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
152: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', -365 ,-364,1 , sysdate, l_user, sysdate, l_user, l_user);
153: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
154: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', -730 ,-364,2 , sysdate, l_user, sysdate, l_user, l_user);
155: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
156: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', -1095 ,-364,3 , sysdate, l_user, sysdate, l_user, l_user);
157:

Line 155: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)

151: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
152: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', -365 ,-364,1 , sysdate, l_user, sysdate, l_user, l_user);
153: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
154: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', -730 ,-364,2 , sysdate, l_user, sysdate, l_user, l_user);
155: insert into HRI_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
156: values ('HRI_ROLLING_YEAR' ,'SEQUENTIAL', -1095 ,-364,3 , sysdate, l_user, sysdate, l_user, l_user);
157:
158: COMMIT;
159: