$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]]>