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

Line 282: FROM gl_periods

278:
279: ELSE
280: SELECT start_date, period_type
281: INTO p_period_start_date, p_period_type
282: FROM gl_periods
283: WHERE period_set_name = pn_period_set_name
284: AND period_name = pn_start_period;
285:
286: SELECT count(*)

Line 288: FROM gl_periods

284: AND period_name = pn_start_period;
285:
286: SELECT count(*)
287: INTO p_max_col
288: FROM gl_periods
289: WHERE period_set_name = pn_period_set_name
290: AND period_type = p_period_type
291: AND start_date >= p_period_start_date;
292:

Line 296: FROM gl_periods

292:
293: -- 14164001: Modified condition to <= from <
294: SELECT count(*)
295: INTO p_min_col
296: FROM gl_periods
297: WHERE period_set_name = pn_period_set_name
298: AND period_type = p_period_type
299: AND start_date <= p_period_start_date;
300: