DBA Data[Home] [Help]

APPS.CS_PARTYMERGE_PKG dependencies on CS_SR_CONTACTS_EXT

Line 377: cs_sr_contacts_ext ex

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';
381:

Line 1300: UPDATE cs_sr_contacts_ext

1296: -- Call Charges party merge routine for sub restrictions.
1297:
1298: FORALL i IN 1..l_rowid_tbl.COUNT
1299:
1300: UPDATE cs_sr_contacts_ext
1301: SET party_id = DECODE(party_id,l_from_party_id_tbl(i),l_to_party_id_tbl(i),party_id)
1302: WHERE rowid = l_rowid_tbl(i);
1303:
1304: l_count := sql%rowcount;