BEN Participation Summary

Description

Application: Advanced Benefits
Source: Participation Summary Report (XML)
Short Name: BENACTIV_XML
DB package: BEN_BENACTIV_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

            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