234: SELECT hp.party_id
235: INTO
236: l_party_id
237: FROM fnd_user fu,
238: hz_parties hp
239: WHERE
240: user_id = l_included_by
241: and employee_id IS NOT NULL
242: and hp.orig_system_reference = 'PER:' || fu.employee_id;
244: WHEN NO_DATA_FOUND THEN
245: SELECT hp.party_id
246: INTO l_party_id
247: FROM fnd_user fu,
248: hz_parties hp
249: WHERE
250: user_id = l_included_by
251: AND employee_id IS NULL
252: -- Bug 4931044: R12 ATG Mandate: Moving customer_id to
761: SELECT hp.party_id
762: INTO
763: l_party_id
764: FROM fnd_user fu,
765: hz_parties hp
766: WHERE
767: user_id = l_implemented_by
768: and employee_id IS NOT NULL
769: and hp.orig_system_reference = 'PER:' || fu.employee_id;
772: SELECT hp.party_id
773: INTO
774: l_party_id
775: FROM fnd_user fu,
776: hz_parties hp
777: WHERE
778: user_id = l_implemented_by
779: and employee_id IS NULL
780: -- Bug 4931044: R12 ATG Mandate: Moving customer_id to