BEN Participation Summary

➜ Back to Library
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Participation Summary Report (XML)
Short Name: BENACTIV_XML
DB package: BEN_BENACTIV_XMLP_PKG
Run BEN Participation Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
            select count(*) LER_CLOSED_AMOUNT,
                       ler.name LER_CLOSED_NAME
            from   ben_batch_ler_info bli,
                       ben_benefit_actions bft,
                       ben_ler_f ler,
                       ben_person_actions bpa
                where  bft.benefit_action_id = bli.benefit_action_id
                and    bft.request_id = :P_CONCURRENT_REQUEST_ID
                and    bli.ler_id=ler.ler_id
                and    bft.process_date between
                         ler.effective_start_date and ler.effective_end_date
                and    (bli.open_and_clsd_flag='Y' or bli.clsd_flag='Y')
                and    bpa.benefit_action_id = bli.benefit_action_id
                and    bpa.person_id = bli.person_id
                and    bpa.action_status_cd  <> 'E'
                group by ler.name
Parameter Name SQL text Validation
Concurrent Request ID 
 
 LOV Oracle
Download
Related Blitz Reports
BEN Participation Process Reports Output BEN Back-out Life Events Audit Log BEN Reconciliation of Premium Contributions to Element Entries BEN Participation Audit Log BEN Close Enrollments Audit Log BEN Process Forfeitures Audit Log BEN Back-out Life Events Summary BEN Process Forfeitures Summary BEN Default Enrollment Audit Log
Blitz Report™

Blitz Report™ provides multiple benefits: