APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_STAGED_CONTACTS

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

853: decode(instrb(s2.TX22,s1.TX22),1,10,
854: 0
855: )
856: score
857: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_CONTACTS s1, HZ_STAGED_CONTACTS s2
858: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
859: and (
860: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
861: -- do an or between all the transformations of an attribute --

Line 1069: from hz_imp_dup_parties h1, HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2

1065: decode(instrb(s2.TX22,s1.TX22),1,10,
1066: 0
1067: )
1068: score
1069: from hz_imp_dup_parties h1, HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1070: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1071: and s1.batch_id = h1.batch_id and s1.party_osr = h1.party_osr and s1.party_os = h1.party_os and s2.party_id = h1.dup_party_id
1072: and (
1073: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1268: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2

1264: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACTS', s1.ORG_CONTACT_ID, s1.CONTACT_OSR, s1.CONTACT_OS,
1265: s2.ORG_CONTACT_ID
1266: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1267: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1268: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1269: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1270: and s1.party_id = s2.party_id
1271: and (
1272: ------------ NON FILTER ATTRIBUTES SECTION ------------------------