Send the current updated or inserted record in Oracle Alert

select ler.name,ppf.first_name,ppf.email_address,ppl.dtctd_dt
INTO &life_event,&emp_name,&email,&dete_date
from per_all_people_f ppf,
ben_ler_f ler,
ben_ptnl_ler_for_per ppl
where 1=1
and ppl.rowid = :ROWID
and ppf.person_id = ppl.PERSON_ID
and ler.ler_id = ppl.ler_id
and trunc(sysdate) between ler.effective_start_date
and ler.effective_end_date
and trunc(sysdate) between ppf.effective_start_date
and ppf.effective_end_date
--and ppf.full_name like '%Jaspal%'
and ler.business_group_id = ppf.business_group_id
and ppl.dtctd_dt is not null
--and ppl.ptnl_ler_for_per_stat_cd <> 'VOIDD'
and ppl.ptnl_ler_for_per_stat_cd = 'DTCTD'