Payroll: Company Totals by Deparment Query

SELECT EV.DEF_ID,SUM(CUR_VALUE) "Current",sum(mtd_value) "Month",sum(qtd_value) "Quarter" , sum(ytd_value) "Year" FROM PRTEMPLOYEE E
LEFT OUTER JOIN prpempdef_empvalues(null,E.EMP_ID,'S',:"Date",:"Period",'N',NULL,NULL,102000,99999999.00) EV ON 1=1
WHERE E.DEPT_NO BETWEEN :BEG_DEPT AND :END_DEPT
group by def_id