APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_DUP_RESULTS

Line 530: insert into hz_dup_results(fid, tid, ord_fid, ord_tid, score)

526: l_party_limit NUMBER := 50000;
527: l_detail_limit NUMBER := 100000;
528: BEGIN
529: FND_FILE.put_line(FND_FILE.log,'Start time of insert of Parties '||to_char(sysdate,'hh24:mi:ss'));
530: insert into hz_dup_results(fid, tid, ord_fid, ord_tid, score)
531: select f, t, least(f,t), greatest(f,t), sum(score) score from (
532: select /*+ ORDERED */ s1.party_id f, s2.party_id t,
533: -------PARTY ENTITY: SCORING SECTION ---------
534: decode(instrb(s2.TX2,s1.TX2),1,80,

Line 633: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2

629: decode(instrb(s2.TX22,s1.TX22),1,5,
630: 0
631: )
632: score
633: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2
634: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
635: and (
636: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
637: -- do an or between all the transformations of an attribute --

Line 649: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);

645: (
646: ((s1.TX11 is null and s2.TX11 is null) or s2.TX11 = s1.TX11)
647: )
648: ) group by f,t ;
649: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);
650: close x_ent_cur;
651: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
652: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
653: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');