641: then
642: begin
643: SELECT fu.user_id, fu.user_name, hp.person_first_name, hp.person_last_name
644: into user_id, user_name, user_firstname, user_lastname
645: FROM fnd_user fu, hz_parties hp
646: WHERE fu.user_name = wf_approver
647: and fu.person_party_id = hp.party_id(+)
648: and rownum = 1;
649: exception
1713: then
1714: begin
1715: SELECT hp.person_first_name, hp.person_last_name
1716: into user_firstname, user_lastname
1717: FROM fnd_user fu, hz_parties hp
1718: WHERE fu.user_name = wf_approver
1719: and fu.person_party_id = hp.party_id(+)
1720: and rownum = 1;
1721: