$P{adtm_end} ) ) OR ( ( dpdeptmaster.deptclose_status = 1 ) AND ( DPDEPTMASTER.DEPTCLOSE_DATE between $P{adtm_bf} and $P{adtm_end} ) ) ) ) AND ( DPDEPTSTATEMENT.OPERATE_DATE between $P{adtm_bf} and $P{adtm_end} ) AND ( DPDEPTTYPE.DEPTTYPE_CODE between $P{as_start_type} and $P{as_end_type} AND MBUCFMEMBGROUP.MEMBGROUP_CODE between $P{membgroup_start} and $P{membgroup_end} ) GROUP BY DPDEPTTYPE.DEPTTYPE_CODE, DPDEPTTYPE.DEPTTYPE_DESC, MBUCFMEMBGROUP.MEMBGROUP_CODE, MBUCFMEMBGROUP.MEMBGROUP_DESC, MBMEMBMASTER.MEMBER_NO, MBUCFPRENAME.PRENAME_DESC, MBMEMBMASTER.MEMB_NAME, MBMEMBMASTER.MEMB_SURNAME, DPDEPTMASTER.DEPTACCOUNT_NO ORDER BY DPDEPTTYPE.DEPTTYPE_CODE , MBUCFMEMBGROUP.MEMBGROUP_CODE ASC]]>