BEN Premium Calculation Summary

Description
Categories: BI Publisher, Human Resources
Application: Advanced Benefits
Source: Premium Calculation Summary Report (XML)
Short Name: BENPRSUM_XML
DB package: BEN_BENPRSUM_XMLP_PKG
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
Parameter NameSQL textValidation
Concurrent Request ID
 
LOV Oracle