= DECODE(TEMP.STTIME,'',1,TEMP.STTIME) AND DECODE(TEMP.ENDTIME,'',1,SUBSTR(B02SO.SALE_DTIME,1,8)) <= DECODE(TEMP.ENDTIME,'',1,TEMP.ENDTIME) ]]>