APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_STAGED_CONTACT_POINTS

Line 574: from hz_dup_worker_chunk_gt p, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2

570: 0
571: )
572: )
573: score
574: from hz_dup_worker_chunk_gt p, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2
575: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
576: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
577: and 1=decode(trap_explosion,'N',1,decode(rownum,l_detail_limit,to_number('A'),1))
578: and (

Line 735: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

731: 0
732: )
733: )
734: score , s1.party_osr party_osr, s1.party_os party_os
735: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
736: where s1.party_id is not null and s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'I'
737: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
738: and (
739: -------CONTACT_POINTS ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 878: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

874: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
875: s2.CONTACT_POINT_ID
876: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
877: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
878: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
879: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
880: and s1.party_id = s2.party_id
881: and (
882: ------------ NON FILTER ATTRIBUTES SECTION ------------------------