APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_STAGED_PARTY_SITES

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

813: decode(instrb(s2.TX22,s1.TX22),1,5,
814: 0
815: )
816: score
817: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2
818: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
819: and (
820: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
821: -- do an or between all the transformations of an attribute --

Line 1029: from hz_imp_dup_parties h1, HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2

1025: decode(instrb(s2.TX22,s1.TX22),1,5,
1026: 0
1027: )
1028: score
1029: from hz_imp_dup_parties h1, HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
1030: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1031: 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
1032: and (
1033: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1215: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2

1211: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
1212: s2.PARTY_SITE_ID
1213: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1214: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1215: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
1216: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1217: and s1.party_id = s2.party_id
1218: and (
1219: ------------ NON FILTER ATTRIBUTES SECTION ------------------------