BEN Participation Process Reports Output

            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