DBA Data[Home] [Help]

APPS.CEFC_VIEW_CONST dependencies on GL_PERIODS

Line 270: FROM gl_periods

266:
267: ELSE
268: SELECT start_date, period_type
269: INTO p_period_start_date, p_period_type
270: FROM gl_periods
271: WHERE period_set_name = pn_period_set_name AND
272: period_name = pn_start_period;
273:
274: SELECT count(*)

Line 276: FROM gl_periods

272: period_name = pn_start_period;
273:
274: SELECT count(*)
275: INTO p_max_col
276: FROM gl_periods
277: WHERE period_set_name = pn_period_set_name AND
278: period_type = p_period_type AND
279: start_date >= p_period_start_date;
280:

Line 283: FROM gl_periods

279: start_date >= p_period_start_date;
280:
281: SELECT count(*)
282: INTO p_min_col
283: FROM gl_periods
284: WHERE period_set_name = pn_period_set_name AND
285: period_type = p_period_type AND
286: start_date < p_period_start_date;
287: