DBA Data[Home] [Help]

APPS.PA_WORKFLOW_HISTORY dependencies on HZ_PARTIES

Line 67: hz_parties hp

63: select party_name
64: from (
65: select fu.user_name, hp.party_name, hp.email_address
66: from fnd_user fu,
67: hz_parties hp
68: where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
69: and fu.user_name = l_user_name
70: union all
71: select fu.user_name, papf.full_name, papf.email_address

Line 73: hz_parties hp,

69: and fu.user_name = l_user_name
70: union all
71: select fu.user_name, papf.full_name, papf.email_address
72: from fnd_user fu,
73: hz_parties hp,
74: per_all_people_f papf
75: where 'PER:' || fu.employee_id = hp.orig_system_reference
76: and fu.user_name = l_user_name
77: and trunc(sysdate)