BEN Participation Process Reports Output

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Advanced Benefits
Source: Participation Process Reports Output(XML)
Short Name: BENERRPA
DB package: BEN_BENERRPA_XMLP_PKG
Run BEN Participation Process Reports Output 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
              union select null,null from dual
Parameter Name SQL text Validation
Concurrent Request id 
 
 Number
Benefit Action id 
 
 Number
Download
Related Blitz Reports
BEN Participation Summary 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 Life Events Summary BEN Back-out Life Events Summary BEN Process Forfeitures Summary
Blitz Report™

Blitz Report™ provides multiple benefits: