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.FII_TIME_ROLLING_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', 0, -6, 0, sysdate, l_user, sysdate, l_user, l_user);

Line: 19


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -7, -6,1, sysdate, l_user, sysdate, l_user, l_user);

Line: 21


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -14, -6, 2, sysdate, l_user, sysdate, l_user, l_user);

Line: 23


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -21,  -6 ,  3, sysdate, l_user, sysdate, l_user, l_user);

Line: 25


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -28 , -6 ,  4, sysdate, l_user, sysdate, l_user, l_user);

Line: 27


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -35,  -6 ,  5, sysdate, l_user, sysdate, l_user, l_user);

Line: 29


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -42,  -6 ,  6, sysdate, l_user, sysdate, l_user, l_user);

Line: 31


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -49,  -6 ,  7, sysdate, l_user, sysdate, l_user, l_user);

Line: 33


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -56,  -6 ,  8 , sysdate, l_user, sysdate, l_user, l_user);

Line: 35


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -63,  -6 ,  9, sysdate, l_user, sysdate, l_user, l_user);

Line: 37


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -70,  -6 , 10, sysdate, l_user, sysdate, l_user, l_user);

Line: 39


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -77,  -6 , 11, sysdate, l_user, sysdate, l_user, l_user);

Line: 41


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'YEARLY', -84,  -6 , 12, sysdate, l_user, sysdate, l_user, l_user);

Line: 43


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY',  0 ,  -29,  0, sysdate, l_user, sysdate, l_user, l_user);

Line: 45


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -30  ,-29,  1 , sysdate, l_user, sysdate, l_user, l_user);

Line: 47


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -60  ,-29,  2  , sysdate, l_user, sysdate, l_user, l_user);

Line: 49


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -90  ,-29,  3   , sysdate, l_user, sysdate, l_user, l_user);

Line: 51


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -120 ,-29,  4 , sysdate, l_user, sysdate, l_user, l_user);

Line: 53


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -150 ,-29,  5 , sysdate, l_user, sysdate, l_user, l_user);

Line: 55


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -180 ,-29,  6 , sysdate, l_user, sysdate, l_user, l_user);

Line: 57


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -210 ,-29,  7 , sysdate, l_user, sysdate, l_user, l_user);

Line: 59


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -240 ,-29,  8 , sysdate, l_user, sysdate, l_user, l_user);

Line: 61


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -270 ,-29,  9 , sysdate, l_user, sysdate, l_user, l_user);

Line: 63


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -300 ,-29, 10 , sysdate, l_user, sysdate, l_user, l_user);

Line: 65


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'YEARLY', -330 ,-29, 11 , sysdate, l_user, sysdate, l_user, l_user);

Line: 67


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'YEARLY',  0   ,-89, 0 , sysdate, l_user, sysdate, l_user, l_user);

Line: 69


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'YEARLY', -90  ,-89, 1 , sysdate, l_user, sysdate, l_user, l_user);

Line: 71


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'YEARLY', -180 ,-89, 2 , sysdate, l_user, sysdate, l_user, l_user);

Line: 73


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'YEARLY', -270 ,-89, 3 , sysdate, l_user, sysdate, l_user, l_user);

Line: 75


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_YEAR'  ,'YEARLY',  0   ,-364, 0 , sysdate, l_user, sysdate, l_user, l_user);

Line: 77


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_YEAR'  ,'YEARLY', -365 ,-364, 1 , sysdate, l_user, sysdate, l_user, l_user);

Line: 79


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_YEAR'  ,'YEARLY', -730 ,-364, 2 , sysdate, l_user, sysdate, l_user, l_user);

Line: 81


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_YEAR'  ,'YEARLY', -1095 ,-364,3 , sysdate, l_user, sysdate, l_user, l_user);

Line: 83


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  0,    -6 , 0 , sysdate, l_user, sysdate, l_user, l_user);

Line: 85


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -7,   -6 , 1 , sysdate, l_user, sysdate, l_user, l_user);

Line: 87


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -14,  -6 , 2 , sysdate, l_user, sysdate, l_user, l_user);

Line: 89


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -21 , -6 , 3 , sysdate, l_user, sysdate, l_user, l_user);

Line: 91


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -28 , -6 , 4 , sysdate, l_user, sysdate, l_user, l_user);

Line: 93


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -35 , -6 , 5 , sysdate, l_user, sysdate, l_user, l_user);

Line: 95


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -42 , -6 , 6 , sysdate, l_user, sysdate, l_user, l_user);

Line: 97


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -49 , -6 , 7 , sysdate, l_user, sysdate, l_user, l_user);

Line: 99


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -56 , -6 , 8 , sysdate, l_user, sysdate, l_user, l_user);

Line: 101


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -63 , -6 , 9 , sysdate, l_user, sysdate, l_user, l_user);

Line: 103


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -70 , -6 , 10 , sysdate, l_user, sysdate, l_user, l_user);

Line: 105


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -77 , -6 , 11 , sysdate, l_user, sysdate, l_user, l_user);

Line: 107


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_WEEK'  ,'SEQUENTIAL',  -84 , -6 , 12 , sysdate, l_user, sysdate, l_user, l_user);

Line: 109


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',   0   ,-29,  0, sysdate, l_user, sysdate, l_user, l_user);

Line: 111


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -30  ,-29,  1, sysdate, l_user, sysdate, l_user, l_user);

Line: 113


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -60  ,-29,  2 , sysdate, l_user, sysdate, l_user, l_user);

Line: 115


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -90  ,-29,  3 , sysdate, l_user, sysdate, l_user, l_user);

Line: 117


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -120 ,-29,  4 , sysdate, l_user, sysdate, l_user, l_user);

Line: 119


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -150 ,-29,  5 , sysdate, l_user, sysdate, l_user, l_user);

Line: 121


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -180 ,-29,  6 , sysdate, l_user, sysdate, l_user, l_user);

Line: 123


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -210 ,-29,  7 , sysdate, l_user, sysdate, l_user, l_user);

Line: 125


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -240 ,-29,  8 , sysdate, l_user, sysdate, l_user, l_user);

Line: 127


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -270 ,-29,  9 , sysdate, l_user, sysdate, l_user, l_user);

Line: 129


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -300 ,-29, 10 , sysdate, l_user, sysdate, l_user, l_user);

Line: 131


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_MONTH' ,'SEQUENTIAL',  -330 ,-29, 11 , sysdate, l_user, sysdate, l_user, l_user);

Line: 133


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'SEQUENTIAL',   0   ,-89, 0  , sysdate, l_user, sysdate, l_user, l_user);

Line: 135


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'SEQUENTIAL',  -90  ,-89, 1 , sysdate, l_user, sysdate, l_user, l_user);

Line: 137


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'SEQUENTIAL',  -180 ,-89, 2 , sysdate, l_user, sysdate, l_user, l_user);

Line: 139


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'SEQUENTIAL',  -270 ,-89, 3 , sysdate, l_user, sysdate, l_user, l_user);

Line: 141


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'SEQUENTIAL',  -360 ,-89, 4 , sysdate, l_user, sysdate, l_user, l_user);

Line: 143


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'SEQUENTIAL',  -450 ,-89, 5 , sysdate, l_user, sysdate, l_user, l_user);

Line: 145


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'SEQUENTIAL',  -540  ,-89,6 , sysdate, l_user, sysdate, l_user, l_user);

Line: 147


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_QTR'   ,'SEQUENTIAL',  -630  ,-89,7 , sysdate, l_user, sysdate, l_user, l_user);

Line: 149


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_YEAR'  ,'SEQUENTIAL',   0   ,-364,0 , sysdate, l_user, sysdate, l_user, l_user);

Line: 151


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_YEAR'  ,'SEQUENTIAL',  -365 ,-364,1 , sysdate, l_user, sysdate, l_user, l_user);

Line: 153


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_YEAR'  ,'SEQUENTIAL',  -730 ,-364,2 , sysdate, l_user, sysdate, l_user, l_user);

Line: 155


insert into fii_time_rolling_offsets(period_type, comparison_type, offset, start_date_offset, period_number, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
values ('FII_ROLLING_YEAR'  ,'SEQUENTIAL',  -1095 ,-364,3 , sysdate, l_user, sysdate, l_user, l_user);