DBA Data[Home] [Help]

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

Line 1717: FROM fnd_user fu, hz_parties hp

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: