634: union
635: select fu.user_name, hp.party_name, hp.email_address
636: from fnd_user fu,
637: hz_parties hp,
638: per_all_people_f papf
639: where
640: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
641: AND 'PER:' = Substr(hp.orig_system_reference,1,4) -- 'PER:' || fu.employee_id = hp.orig_system_reference
642: and hp.party_id = l_proj_mgr_id
840: union
841: select fu.user_name, hp.party_name, hp.email_address
842: from fnd_user fu,
843: hz_parties hp,
844: per_all_people_f papf
845: where
846: --'PER:' || fu.employee_id = hp.orig_system_reference
847: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
848: AND 'PER:' = Substr(hp.orig_system_reference,1,4)
956: union
957: select fu.user_name, hp.party_name, hp.email_address
958: from fnd_user fu,
959: hz_parties hp,
960: per_all_people_f papf
961: where
962: --'PER:' || fu.employee_id = hp.orig_system_reference
963: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
964: AND 'PER:' = Substr(hp.orig_system_reference,1,4)