Subversion Repositories DevTools

Rev

Rev 64 | Blame | Compare with Previous | Last modification | View Log | RSS feed

/* Release To State List */
SELECT st.STATE_ID,
           st.STATE_NAME,
           DECODE( :TOSTATE_ID,
                           st.STATE_ID, 'selected', NULL) AS SELECTED
  FROM STATES st
 WHERE st.PROJ_ID = :PROJ_ID 
   AND st.STATE_SEQ > :STATE_SEQ
 ORDER BY st.STATE_SEQ