APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_DUP_WORKER_CHUNK_GT

Line 708: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTIES s1, HZ_STAGED_PARTIES s2

704: decode(instrb(s2.TX45,s1.TX45),1,200,
705: 0
706: )
707: score
708: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTIES s1, HZ_STAGED_PARTIES s2
709: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
710: and nvl(s1.status,'A') = 'A' and nvl(s2.status,'A') = 'A'
711: and 1=decode(trap_explosion,'N',1,decode(rownum,l_party_limit,to_number('A'),1))
712: and (

Line 749: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2

745: decode(instrb(s2.TX22,s1.TX22),1,5,
746: 0
747: )
748: score
749: from hz_dup_worker_chunk_gt p, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2
750: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
751: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
752: and 1=decode(trap_explosion,'N',1,decode(rownum,l_detail_limit,to_number('A'),1))
753: and (

Line 808: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2

804: 0
805: )
806: )
807: score
808: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2
809: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
810: and (
811: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
812: -- do an or between all the transformations of an attribute --

Line 847: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_CONTACTS s1, HZ_STAGED_CONTACTS s2

843: decode(instrb(s2.TX22,s1.TX22),1,10,
844: 0
845: )
846: score
847: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_CONTACTS s1, HZ_STAGED_CONTACTS s2
848: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
849: and (
850: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
851: -- do an or between all the transformations of an attribute --