APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_STAGED_CONTACT_POINTS

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 1011: from hz_imp_dup_parties h1, HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

1007: 0
1008: )
1009: )
1010: score
1011: from hz_imp_dup_parties h1, HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
1012: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1013: 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
1014: and (
1015: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1188: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

1184: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
1185: s2.CONTACT_POINT_ID
1186: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1187: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1188: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
1189: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1190: and s1.party_id = s2.party_id
1191: and (
1192: ------------ NON FILTER ATTRIBUTES SECTION ------------------------