How to find your gl period end date

SELECT gps.end_date
  FROM gl_period_statuses gps
 WHERE gps.application_id = '222'
   AND gps.closing_status = 'O'
   AND gps.start_date =
            (SELECT MAX (gpss.start_date)
               FROM gl_period_statuses gpss
              WHERE gpss.application_id = '222' AND gpss.closing_status = 'O');