WITH t AS
(
SELECT 'FI201509160004' pk, '10' gb, 1 seq, '0000001402' id, '00' st FROM dual
UNION ALL SELECT 'FI201509160004', '10', 2, '0000001269', '00' FROM dual
)
SELECT *
  FROM t m
 WHERE id = :v_id
   AND st = '00'
   AND NOT EXISTS (SELECT 0
                     FROM t s
                    WHERE s.pk  = m.pk
                      AND s.seq > m.seq
                      AND s.st  = '00'
                   )
;

마농님... 감사합니다.. ㅜㅜ