373: BEGIN
374: SELECT PERIOD_NAME
375: INTO lv_period_from
376: FROM (SELECT PERIOD_NAME
377: FROM GL_PERIOD_STATUSES
378: WHERE APPLICATION_ID = 101
379: AND LEDGER_ID = pn_ledger_id
380: AND PERIOD_YEAR = pv_accounting_year
381: AND CLOSING_STATUS <> 'N'
395: BEGIN
396: SELECT PERIOD_NAME
397: INTO lv_period_to
398: FROM (SELECT PERIOD_NAME
399: FROM GL_PERIOD_STATUSES
400: WHERE APPLICATION_ID = 101
401: AND LEDGER_ID = pn_ledger_id
402: AND PERIOD_YEAR = pv_accounting_year
403: AND CLOSING_STATUS <> 'N'