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.FUN_PERIOD_STATUS_PKG dependencies on GL_PERIODS

Line 1853: from gl_periods,fun_system_options

1849: ,FND_GLOBAL.LOGIN_ID
1850: ,sysdate
1851: ,inteco_calendar
1852: ,inteco_period_type
1853: from gl_periods,fun_system_options
1854: where period_set_name = p_per_set_name and period_type = p_per_type and
1855: period_year >p_per_year;
1856: END;
1857: PROCEDURE insert_details_for_periods (p_per_year number , p_per_type varchar2 , p_per_set_name varchar2 , p_period_num number,p_trx_type_id number )

Line 1891: from gl_periods,

1887: ,FND_GLOBAL.LOGIN_ID
1888: ,sysdate
1889: ,INTECO_CALENDAR
1890: ,INTECO_PERIOD_TYPE
1891: from gl_periods,
1892: fun_system_options
1893: where period_set_name = p_per_set_name and period_type = p_per_type and
1894: period_year =p_per_year and period_num > p_period_num ;
1895: END;

Line 1898: select min(period_year) from gl_periods gl, fun_system_options fun

1894: period_year =p_per_year and period_num > p_period_num ;
1895: END;
1896: PROCEDURE sync_calendars IS
1897: CURSOR c_min_gl_per_yr IS
1898: select min(period_year) from gl_periods gl, fun_system_options fun
1899: where
1900: gl.period_set_name = fun.inteco_calendar
1901: and gl.period_type = fun.inteco_period_type ;
1902: CURSOR c_max_gl_per_yr IS

Line 1903: select max(period_year) from gl_periods gl, fun_system_options fun

1899: where
1900: gl.period_set_name = fun.inteco_calendar
1901: and gl.period_type = fun.inteco_period_type ;
1902: CURSOR c_max_gl_per_yr IS
1903: select max(period_year) from gl_periods gl, fun_system_options fun
1904: where
1905: gl.period_set_name = fun.inteco_calendar
1906: and gl.period_type = fun.inteco_period_type ;
1907: CURSOR c_max_gl_per_num(c_per_year number)IS

Line 1908: select max(period_num) from gl_periods gl , fun_system_options fun

1904: where
1905: gl.period_set_name = fun.inteco_calendar
1906: and gl.period_type = fun.inteco_period_type ;
1907: CURSOR c_max_gl_per_num(c_per_year number)IS
1908: select max(period_num) from gl_periods gl , fun_system_options fun
1909: where
1910: gl.period_set_name = fun.inteco_calendar
1911: and gl.period_type = fun.inteco_period_type
1912: and gl.period_year = c_per_year;