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.JL_ZZ_FA_REVAL_RULES_PKG dependencies on FA_CALENDAR_PERIODS

Line 296: FROM fa_calendar_periods

292: g_step := 'PREVIOUS PERIOD';
293:
294: SELECT period_num
295: INTO g_period_num
296: FROM fa_calendar_periods
297: WHERE calendar_type = g_calendar_type
298: AND start_date = g_current_period_from_date1;
299:
300: SELECT start_date,end_date

Line 303: FROM fa_calendar_periods

299:
300: SELECT start_date,end_date
301: INTO g_current_period_from_date2,
302: g_current_period_to_date2
303: FROM fa_calendar_periods
304: WHERE calendar_type = g_calendar_type
305: AND period_num = decode(g_period_num,1,g_number_per_fy,g_period_num-1)
306: AND end_date = g_current_period_from_date1 - 1;
307:

Line 432: FROM fa_calendar_periods

428:
429:
430: SELECT decode(g_country_code, 'CL',(start_date-1), end_date)
431: INTO l_close_date
432: FROM fa_calendar_periods
433: WHERE calendar_type = g_calendar_type
434: AND trunc(p_date) BETWEEN start_date AND end_date;
435:
436: