APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_STAGED_PARTY_SITES

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

629: decode(instrb(s2.TX22,s1.TX22),1,5,
630: 0
631: )
632: score
633: from hz_dup_worker_chunk_gt p, hz_dup_results h1, HZ_STAGED_PARTY_SITES s1, HZ_STAGED_PARTY_SITES s2
634: where p.party_id=h1.fid and s1.party_id = h1.fid and s2.party_id = h1.tid
635: and (
636: ------------ NON FILTER ATTRIBUTES SECTION ------------------------
637: -- do an or between all the transformations of an attribute --

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

789: decode(instrb(s2.TX22,s1.TX22),1,5,
790: 0
791: )
792: score
793: from hz_imp_dup_parties h1, HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
794: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
795: 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
796: and (
797: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 936: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2

932: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
933: s2.PARTY_SITE_ID
934: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
935: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
936: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
937: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
938: and s1.party_id = s2.party_id
939: and (
940: ------------ NON FILTER ATTRIBUTES SECTION ------------------------