[Home] [Help]
269: --Get the last period number of the previous year
270: log(l_module, ' getting last period of the previous year. ');
271: SELECT MAX(period_num)
272: INTO g_period_num_high
273: FROM gl_period_statuses
274: WHERE period_year = g_fiscal_year - 1
275: AND application_id = 101
276: AND closing_status <> 'F'
277: AND closing_status <> 'N'