Checando Periodos Oracle

Pessoal,

Tô passando somente pra deixar um exemplo de como checar status dos Períodos do Oracle EBS.

Segue:

 SELECT GS.PERIOD_NAME,
        FA.APPLICATION_NAME,
        GS.CLOSING_STATUS,
        GS.SET_OF_BOOKS_ID,
        DECODE(GS.CLOSING_STATUS,
               'C',
               'Closed',
               'O',
               'Open',
               'F',
               'Future',
               'W',
               'Closed Pending',
               'N',
               'Never Opened',
               'P',
               'Permanently Closed') "PERIOD_CLOSING_STATUS"
   FROM GL.GL_PERIOD_STATUSES GS, APPS.FND_APPLICATION_TL FA
  WHERE FA.APPLICATION_ID = GS.APPLICATION_ID
    AND FA.APPLICATION_NAME IN
        ('Payables', 'Receivables', 'General Ledger')
    AND GS.SET_OF_BOOKS_ID = 5       -- ID DO LIVRO
    AND GS.PERIOD_NAME IN ('JAN-13') -- NOME PERIODO
    AND CLOSING_STATUS IN ('O', 'W', 'C')
  GROUP BY PERIOD_NAME, APPLICATION_NAME, GS.CLOSING_STATUS,GS.SET_OF_BOOKS_ID
  ORDER BY PERIOD_NAME DESC;

Abs,
Júnio Vitor