APPS.PA_WORKFLOW_HISTORY dependencies on FND_USER

Line 15: 05-Aug-2005 raluthra Bug 4527617: Replaced fnd_user.customer_id with

11:
12:
13:
14: HISTORY : 08/19/02 SYAO Initial Creation
15: 05-Aug-2005 raluthra Bug 4527617: Replaced fnd_user.customer_id with
16: fnd_user.person_party_id for R12 ATG Mandate Fix.
17: 18-Aug-2005 avaithia Bug 4537865 : NOCOPY Mandate Changes.
18: 21-Apr-2006 avaithia Bug 5178531 : SWAN Changes
19: Changed these color codes :

Line 16: fnd_user.person_party_id for R12 ATG Mandate Fix.

12:
13:
14: HISTORY : 08/19/02 SYAO Initial Creation
15: 05-Aug-2005 raluthra Bug 4527617: Replaced fnd_user.customer_id with
16: fnd_user.person_party_id for R12 ATG Mandate Fix.
17: 18-Aug-2005 avaithia Bug 4537865 : NOCOPY Mandate Changes.
18: 21-Apr-2006 avaithia Bug 5178531 : SWAN Changes
19: Changed these color codes :
20: replaced #cccc99 with #cfe0f1

Line 66: from fnd_user fu,

62: IS
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

Line 72: from fnd_user fu,

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
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