SELECT PERIOD_NAME , START_DATE , END_DATE FROM GL_PERIOD_STATUSES G , GL_SETS_OF_BOOKS B WHERE B.SET_OF_BOOKS_ID = G.SET_OF_BOOKS_ID AND G.APPLICATION_ID = 101 AND G.SET_OF_BOOKS_ID = PN_MO_CACHE_UTILS.GET_PROFILE_VALUE('PN_SET_OF_BOOKS_ID') AND G.PERIOD_TYPE = B.ACCOUNTED_PERIOD_TYPE AND G.ADJUSTMENT_PERIOD_FLAG = 'N' AND CLOSING_STATUS IN ('O' , 'F') ORDER BY EFFECTIVE_PERIOD_NUM