APPS.PA_CI_IMPACTS_PVT dependencies on HZ_PARTIES

Line 230: hz_parties hp

226:
227: CURSOR get_internal_party_id
228: IS
229: select hp.party_id from fnd_user fu,
230: hz_parties hp
231: where
232: user_id = FND_GLOBAL.user_id
233: and employee_id is not null
234: and hp.orig_system_reference = 'PER:' || fu.employee_id;

Line 240: hz_parties hp

236:
237: CURSOR get_external_party_id
238: IS
239: select hp.party_id from fnd_user fu,
240: hz_parties hp
241: where
242: user_id = FND_GLOBAL.user_id
243: and employee_id is null
244: and hp.party_id = fu.person_party_id; -- fu.customer_id; Changed for Bug 4527617

Line 248: hz_parties

244: and hp.party_id = fu.person_party_id; -- fu.customer_id; Changed for Bug 4527617
245:
246: CURSOR get_party_id is
247: SELECT party_id FROM
248: hz_parties
249: WHERE party_name = p_impby_name;
250:
251:
252: CURSOR get_impact_name