BEN Participation Process Reports Output

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