Subversion Repositories DevTools

Rev

Rev 13 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* Release To State List */
2 
SELECT st.STATE_ID,
3 
	   st.STATE_NAME,
4 
	   DECODE( :TOSTATE_ID,
5 
	   		   st.STATE_ID, 'selected', NULL) AS SELECTED
6 
  FROM STATES st
7 
 WHERE st.PROJ_ID = :PROJ_ID
8 
   AND st.STATE_SEQ > :STATE_SEQ
9 
 ORDER BY st.STATE_SEQ