SELECT PRD.PERIOD_NAME , PRD.END_DATE , PRD.START_DATE , 0 REQUEST_ID FROM GL_SETS_OF_BOOKS SOB , GL_PERIODS PRD WHERE SOB.SET_OF_BOOKS_ID = OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID AND SOB.PERIOD_SET_NAME = PRD.PERIOD_SET_NAME AND SOB.ACCOUNTED_PERIOD_TYPE = PRD.PERIOD_TYPE AND NVL(PRD.ADJUSTMENT_PERIOD_FLAG , 'N') = 'N' ORDER BY PERIOD_YEAR DESC , PERIOD_NUM DESC