APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_STAGED_CONTACT_POINTS

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

744: 0
745: )
746: )
747: score
748: from hz_dup_worker_chunk_gt p, HZ_STAGED_CONTACT_POINTS s1, HZ_STAGED_CONTACT_POINTS s2
749: where p.party_id = s1.party_id and s1.party_id<>s2.party_id
750: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
751: and 1=decode(trap_explosion,'N',1,decode(rownum,l_detail_limit,to_number('A'),1))
752: and (

Line 966: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

962: 0
963: )
964: )
965: score , s1.party_osr party_osr, s1.party_os party_os
966: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
967: 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'
968: and exists(SELECT 1 from hz_staged_parties q where q.party_id = s2.party_id and nvl(q.status,'A') = 'A')
969: and (
970: -------CONTACT_POINTS ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 1152: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2

1148: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACT_POINTS', s1.CONTACT_POINT_ID, s1.CONTACT_PT_OSR, s1.CONTACT_PT_OS,
1149: s2.CONTACT_POINT_ID
1150: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1151: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1152: from HZ_SRCH_CPTS s1, HZ_STAGED_CONTACT_POINTS s2
1153: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1154: and s1.party_id = s2.party_id
1155: and (
1156: ------------ NON FILTER ATTRIBUTES SECTION ------------------------