SQL to check Purchasing Period Status

SELECT
(select name from v$database) DBNAME,
(select sysdate from dual) Extract_Date,
gled.name "Ledger",
         hou.name "Operating Unit",
         GPS.SHOW_STATUS "Period Status",
         GPS.PERIOD_NUM "Period Number",
         GPS.PERIOD_YEAR "Fiscal Year",
         GPS.PERIOD_NAME "Period Name",
         TO_CHAR (GPS.START_DATE, 'DD-MON-YYYY') "Begin Date",
         TO_CHAR (GPS.END_DATE, 'DD-MON-YYYY') "End Date"
    FROM apps.GL_PERIOD_STATUSES_V GPS,
         apps.hr_operating_units hou,
         apps.gl_ledgers gled
   WHERE     application_id = 200
         AND gps.PERIOD_YEAR = 2016
         AND hou.SET_OF_BOOKS_ID = GPS.SET_OF_BOOKS_ID
         AND gled.ledger_id = HOU.SET_OF_BOOKS_ID
     ORDER BY hou.name