439: l_out_person_name ghr_pa_routing_history.user_name%TYPE;
440: --
441: cursor csr_pa is
442: select substr(usr.user_name,1,30) user_name
443: from per_assignments_f paf
444: ,per_people_f ppf
445: ,fnd_user usr
446: where paf.person_id = l_in_person_id
447: and paf.primary_flag = 'Y'