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

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