BEN Error By Person Report(Comm.)

select b.full_name FULL_NAME,
          a.person_id PERSON_ID,
          a.national_identifier NATIONAL_IDENTIFIER
from  ben_reporting a,
         ben_benefit_actions c,
         per_people_f b
where  c.request_id = :P_CONCURRENT_REQUEST_ID
and      c.benefit_action_id = a.benefit_action_id
and      a.rep_typ_cd in ('ERRCM', 'FATAL')
and      a.person_id = b.person_id
and      c.process_date
            between b.effective_start_date
            and        b.effective_end_date 
order    by a.national_identifier asc