0 and not exists ( select 1 from mbadjsalary mas where mas.coop_id = $P{as_coopid} and mas.operate_date = $P{adtm_operate} and mas.posting_flag = 1 and mas.coop_id = m.coop_id and mas.member_no = m.member_no ) union select mug.membgroup_code , mug.membgroup_desc , m.member_no , mup.prename_desc , m.memb_name , m.memb_surname , m.salary_id , m.work_date from mbmembmaster m , mbucfprename mup , mbucfmembgroup mug , ( select count(1) as cntadj from mbadjsalary where coop_id = $P{as_coopid} and operate_date = $P{adtm_operate} and posting_flag = 1 ) mac where m.coop_id = mug.coop_id(+) and m.membgroup_code = mug.membgroup_code(+) and m.prename_code = mup.prename_code(+) and m.coop_id = $P{as_coopid} and m.member_date <= $P{adtm_operate} and m.resign_date > $P{adtm_operate} and m.resign_status = 1 and mac.cntadj > 0 and not exists ( select 1 from mbadjsalary mas where mas.coop_id = $P{as_coopid} and mas.operate_date = $P{adtm_operate} and mas.posting_flag = 1 and mas.coop_id = m.coop_id and mas.member_no = m.member_no ) ) order by member_no]]>