APPS.POS_SUPP_APPR dependencies on HZ_PARTIES

Line 645: FROM fnd_user fu, hz_parties hp

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