BEN Process Forfeitures Summary
Description
- Categories
- BI Publisher
- Application
- Advanced Benefits
- Source
- Process Forfeitures Summary Report (XML)
- Short Name
- BENFRSUM_XML
- DB package
- BEN_BENFRSUM_XMLP_PKG
SQL 15 lines
select pl.name PLAN_NAME , rpt.val pl_total_frfd_val, rpt.ler_id pl_cntr_val, related_person_id pl_distr_val from ben_reporting rpt, ben_benefit_actions bba, ben_pl_f pl where rpt.rep_typ_cd IN ('FRPLVAL') 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 order by pl.name |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Concurrent Request ID | LOV Oracle |