APPS.CS_PARTYMERGE_PKG dependencies on HZ_MERGE_PARTIES

Line 335: FROM hz_merge_parties

331: CURSOR c_Get_Merged_Parties IS
332: SELECT batch_party_id ,
333: from_party_id ,
334: to_party_id
335: FROM hz_merge_parties
336: WHERE merge_reason_code <> 'SAME_PARTY_MERGE'
337: AND batch_id = p_batch_id;
338:
339: -- Cursor to get impacted Contact point transactions due to party merge using TCA log table and CS_HZ_SR_Contact_Points table.

Line 361: FROM hz_merge_parties p,

357: SELECT p.batch_party_id,
358: p.from_party_id ,
359: p.to_party_id ,
360: cc.sr_contact_point_id
361: FROM hz_merge_parties p,
362: cs_hz_sr_contact_points cc
363: WHERE p.merge_type <> 'SAME_PARTY_MERGE'
364: AND p.batch_id = p_batch_id
365: AND p.from_party_id = cc.party_id

Line 376: FROM hz_merge_parties p,

372: ex.extension_id,
373: ex.party_id ,
374: p.from_party_id ,
375: p.to_party_id
376: FROM hz_merge_parties p,
377: cs_sr_contacts_ext ex
378: WHERE ex.party_id = p.from_party_id
379: AND p.batch_id = p_batch_id
380: AND p.merge_type <> 'SAME_PARTY_MERGE';