14: l_orig_sys:= SubStr(p_mail_to,1,l_sep_index-1);
15: l_name :=SubStr(p_mail_to,l_sep_index+1,length(p_mail_to));
16: if l_orig_sys='PER' then
17: select user_name into l_receiver 18: from ego_people_v 19: where user_name=l_name
20: and rownum=1;
21: elsif l_orig_sys='GROUP' then
22: select 'HZ_GROUP:'||group_id into l_receiver