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(*)
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:
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: