APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_STAGED_CONTACTS

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 --

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

1046: decode(instrb(s2.TX22,s1.TX22),1,10,
1047: 0
1048: )
1049: score
1050: from hz_imp_dup_parties h1, HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1051: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1052: 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
1053: and (
1054: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1240: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2

1236: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACTS', s1.ORG_CONTACT_ID, s1.CONTACT_OSR, s1.CONTACT_OS,
1237: s2.ORG_CONTACT_ID
1238: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1239: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1240: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1241: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1242: and s1.party_id = s2.party_id
1243: and (
1244: ------------ NON FILTER ATTRIBUTES SECTION ------------------------