Query to find the GL Status:


select
gl.name,
gps.PERIOD_NAME,
fa.application_SHORT_name,
gps.CLOSING_STATUS,
gps.START_DATE,
gps.application_id,
gps.END_DATE,
gps.last_updated_by  from GL_PERIOD_STATUSES gps,
GL_LEDGERS gl,
FND_application fA
where 
gl.ledger_id=gps.ledger_id
and gl.name in ('GL')
and fa.application_id=gps.application_id
and PERIOD_NAME like ('%16%')

and fa.application_SHORT_name like 'GL'