404: BEGIN
405: SELECT PERIOD_NAME
406: INTO lv_period_from
407: FROM (SELECT PERIOD_NAME
408: FROM GL_PERIOD_STATUSES
409: WHERE APPLICATION_ID = 101
410: AND LEDGER_ID = pn_ledger_id
411: AND PERIOD_YEAR = pv_accounting_year
412: AND CLOSING_STATUS <> 'N'
426: BEGIN
427: SELECT PERIOD_NAME
428: INTO lv_period_to
429: FROM (SELECT PERIOD_NAME
430: FROM GL_PERIOD_STATUSES
431: WHERE APPLICATION_ID = 101
432: AND LEDGER_ID = pn_ledger_id
433: AND PERIOD_YEAR = pv_accounting_year
434: AND CLOSING_STATUS <> 'N'