311: BEGIN
312: SELECT PERIOD_NAME
313: INTO lv_period_from
314: FROM (SELECT PERIOD_NAME
315: FROM GL_PERIOD_STATUSES
316: WHERE APPLICATION_ID = 101
317: AND LEDGER_ID = pn_ledger_id
318: AND PERIOD_YEAR = pv_accounting_year
319: AND CLOSING_STATUS <> 'N'
331: BEGIN
332: SELECT PERIOD_NAME
333: INTO lv_period_to
334: FROM (SELECT PERIOD_NAME
335: FROM GL_PERIOD_STATUSES
336: WHERE APPLICATION_ID = 101
337: AND LEDGER_ID = pn_ledger_id
338: AND PERIOD_YEAR = pv_accounting_year
339: AND CLOSING_STATUS <> 'N'