DBA Data[Home] [Help]

APPS.PA_FP_CI_MERGE dependencies on HZ_PARTIES

Line 238: hz_parties hp

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;

Line 248: hz_parties hp

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

Line 765: hz_parties hp

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;

Line 776: hz_parties hp

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