SELECT period_name FROM gl_period_statuses WHERE application_id = 101 AND set_of_books_id = fnd_profile.VALUE('GL_SET_OF_BKS_ID') ORDER BY effective_period_num DESC
View Text - HTML Formatted
SELECT PERIOD_NAME FROM GL_PERIOD_STATUSES WHERE APPLICATION_ID = 101 AND SET_OF_BOOKS_ID = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID') ORDER BY EFFECTIVE_PERIOD_NUM DESC