DBA Data[Home] [Help]

APPS.PA_WORKFLOW_HISTORY dependencies on HZ_PARTIES

Line 62: hz_parties hp

58: select party_name
59: from (
60: select fu.user_name, hp.party_name, hp.email_address
61: from fnd_user fu,
62: hz_parties hp
63: where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
64: and fu.user_name = l_user_name
65: union all
66: select fu.user_name, papf.full_name, papf.email_address

Line 68: hz_parties hp,

64: and fu.user_name = l_user_name
65: union all
66: select fu.user_name, papf.full_name, papf.email_address
67: from fnd_user fu,
68: hz_parties hp,
69: per_all_people_f papf
70: where 'PER:' || fu.employee_id = hp.orig_system_reference
71: and fu.user_name = l_user_name
72: and trunc(sysdate)