'' then emp.salexp_accid || ' ' || dp.deptaccount_name else '' end ) as accid_desc from hrpayroll pr, hrpayrolldet pd, hremployee emp, mbucfprename mpre, hrucfsalaryitem hucf, dpdeptmaster dp where ( pr.coop_id = pd.coop_id ) and ( pr.payrollslip_no = pd.payrollslip_no ) and ( pr.coop_id = emp.coop_id ) and ( pr.emp_no = emp.emp_no ) and ( emp.prename_code = mpre.prename_code ) and ( pd.salitem_code = hucf.salitem_code ) and ( emp.salexp_accid = dp.deptaccount_no (+) ) and (( pr.coop_id = $P{as_coopid} ) and ( pr.payroll_period = $P{as_period} ) and ( emp.emptype_code = $P{as_emptype} )) group by emp.emp_no, mpre.prename_desc, emp.emp_name, emp.emp_surname, emp.salexp_accid, dp.deptaccount_name order by emp.emp_no]]>