APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on HZ_PARTIES

Line 1841: hz_parties hp

1837: -- select party_name from
1838: --(
1839: select hp.party_name
1840: from fnd_user fu,
1841: hz_parties hp
1842: where fu.user_name = l_forward_to --fnd_global.user_id
1843: and fu.employee_id is null
1844: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
1845: union

Line 1848: hz_parties hp

1844: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
1845: union
1846: select hp.party_name
1847: from fnd_user fu,
1848: hz_parties hp
1849: where fu.user_name = l_forward_to--fnd_global.user_id
1850: and fu.employee_id is not null
1851: and 'PER:' || fu.employee_id = hp.orig_system_reference;
1852: --);