BEN Premium Calculation Summary

select sum(decode(rpt.rep_typ_cd, 'PRCREDIT', -rpt.val, rpt.val)) SUM_PL_PREM, pl.name PLAN_NAME
from ben_reporting rpt, ben_benefit_actions bba, ben_pl_f pl
where  rpt.rep_typ_cd IN ('PRPLOIPL', 'PRCURMOP',  'PRCREDIT')
and bba.request_id = :P_CONCURRENT_REQUEST_ID
and bba.benefit_action_id = rpt.benefit_action_id
and rpt.pl_id = pl.pl_id
and sysdate between
pl.effective_start_date and pl.effective_end_date
group by pl.name