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 1345: from gl_periods,fun_system_options

1341: ,FND_GLOBAL.LOGIN_ID
1342: ,sysdate
1343: ,inteco_calendar
1344: ,inteco_period_type
1345: from gl_periods,fun_system_options
1346: where period_set_name = p_per_set_name and period_type = p_per_type and
1347: period_year >p_per_year;
1348: END;
1349: 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 1383: from gl_periods,

1379: ,FND_GLOBAL.LOGIN_ID
1380: ,sysdate
1381: ,INTECO_CALENDAR
1382: ,INTECO_PERIOD_TYPE
1383: from gl_periods,
1384: fun_system_options
1385: where period_set_name = p_per_set_name and period_type = p_per_type and
1386: period_year =p_per_year and period_num > p_period_num ;
1387: END;

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

1386: period_year =p_per_year and period_num > p_period_num ;
1387: END;
1388: PROCEDURE sync_calendars IS
1389: CURSOR c_min_gl_per_yr IS
1390: select min(period_year) from gl_periods gl, fun_system_options fun
1391: where
1392: gl.period_set_name = fun.inteco_calendar
1393: and gl.period_type = fun.inteco_period_type ;
1394: CURSOR c_max_gl_per_yr IS

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

1391: where
1392: gl.period_set_name = fun.inteco_calendar
1393: and gl.period_type = fun.inteco_period_type ;
1394: CURSOR c_max_gl_per_yr IS
1395: select max(period_year) from gl_periods gl, fun_system_options fun
1396: where
1397: gl.period_set_name = fun.inteco_calendar
1398: and gl.period_type = fun.inteco_period_type ;
1399: CURSOR c_max_gl_per_num(c_per_year number)IS

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

1396: where
1397: gl.period_set_name = fun.inteco_calendar
1398: and gl.period_type = fun.inteco_period_type ;
1399: CURSOR c_max_gl_per_num(c_per_year number)IS
1400: select max(period_num) from gl_periods gl , fun_system_options fun
1401: where
1402: gl.period_set_name = fun.inteco_calendar
1403: and gl.period_type = fun.inteco_period_type
1404: and gl.period_year = c_per_year;