'TSA' ) and ( SLSLIPPAYOUT.SLIP_STATUS = 1 ) and ( SLSLIPPAYOUT.COOP_ID = $P{coop_id}) and (SLSLIPPAYOUT.COOP_ID =CMCOOPMASTER.COOP_ID ) and ( SLSLIPPAYOUT.SLIP_DATE between $P{adtm_sdate} and $P{adtm_edate} ) ) and resignreq_status =1 ORDER BY SLSLIPPAYOUT.OPERATE_DATE ASC, SLSLIPPAYOUT.DOCUMENT_NO ASC]]>