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
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
Parameter Name SQL text Validation
Concurrent Request ID
 
LOV Oracle