'1') b ORDER BY B.SLAB_NO ]]> '1' ) b WHERE b.SUB_SLAB_NO(+) like a.CHARGE_NO||'%' ORDER BY B.SLAB_NO ]]> '1') b ORDER BY B.SLAB_NO ]]> '1' ) b WHERE b.SUB_SLAB_NO(+) like a.CHARGE_NO||'%' ORDER BY B.SLAB_NO ]]> T.SUB_SLAB_NO AND SUBSTR(T.SLAB_NO,11,2) > '50' ),'1',( SELECT DECODE(MAX(T.SLAB_NO),'',?||'01'||'0',?||lpad((SUBSTR(MAX(T.SLAB_NO),11,2)+1),2,'0')||'0') FROM TBG02_SLAB_COMM T WHERE T.STRAND_NO = '1' AND T.SUB_SLAB_NO LIKE ?||'%' --AND T.SUB_SLAB_NO <> T.SLAB_NO AND SUBSTR(T.SLAB_NO,11,2) < '50' )) WHERE T.PLAN_SLAB_NO = ? AND T.SLAB_STAT = '1' ]]> {CALL HCR_SLABNO_UPD(?)}