APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_SRCH_CONTACTS

Line 369: INSERT INTO HZ_SRCH_CONTACTS (

365: END LOOP;
366: SAVEPOINT pop_contacts;
367: BEGIN
368: FORALL I in H_P_CONTACT_OSR.FIRST..H_P_CONTACT_OSR.LAST
369: INSERT INTO HZ_SRCH_CONTACTS (
370: TX22, PARTY_OS, PARTY_OSR, CONTACT_OS, CONTACT_OSR, NEW_PARTY_FLAG, BATCH_ID, INT_ROW_ID, PARTY_ID , TX2, TX23
371: ) VALUES (
372: H_TX22(I), H_P_SUBJECT_OS(I), H_P_SUBJECT_OSR(I), H_P_CONTACT_OS(I), H_P_CONTACT_OSR(I), H_P_N_PARTY(I), P_BATCH_ID, H_P_ROW_ID(I), H_CT_OBJ_ID(I) , H_CT_CUST_TX2(I), H_CT_CUST_TX23(I)
373: );

Line 655: INSERT INTO HZ_SRCH_CONTACTS (

651: END LOOP;
652: SAVEPOINT pop_contacts_int;
653: BEGIN
654: FORALL I in H_P_CONTACT_OS.FIRST..H_P_CONTACT_OS.LAST
655: INSERT INTO HZ_SRCH_CONTACTS (
656: TX22, PARTY_OS, PARTY_OSR, CONTACT_OS, CONTACT_OSR, BATCH_ID, INT_ROW_ID , TX2, TX23
657: ) VALUES (
658: H_TX22(I), H_P_SUBJECT_OS(I), H_P_SUBJECT_OSR(I), H_P_CONTACT_OS(I), H_P_CONTACT_OSR(I), P_BATCH_ID, H_P_ROW_ID(I) , H_CT_CUST_TX2(I), H_CT_CUST_TX23(I)
659: );

Line 1050: from hz_imp_dup_parties h1, HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2

1046: decode(instrb(s2.TX22,s1.TX22),1,10,
1047: 0
1048: )
1049: score
1050: from hz_imp_dup_parties h1, HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1051: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1052: 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
1053: and (
1054: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1240: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2

1236: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACTS', s1.ORG_CONTACT_ID, s1.CONTACT_OSR, s1.CONTACT_OS,
1237: s2.ORG_CONTACT_ID
1238: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1239: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1240: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1241: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1242: and s1.party_id = s2.party_id
1243: and (
1244: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1447: from hz_int_dup_results h1, HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2

1443: decode(instrb(s2.TX22,s1.TX22),1,10,
1444: 0
1445: )
1446: score
1447: from hz_int_dup_results h1, HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2
1448: where
1449: s1.party_osr = h1.f_osr and s2.party_osr = h1.t_osr and h1.batch_id = p_batch_id
1450: and s1.party_osr between from_osr and to_osr
1451: and (

Line 1584: from HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2

1580: )
1581: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1582: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1583: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1584: from HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2
1585: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1586: and ( ( (s1.party_osr = s2.party_osr) and ( nvl(s1.party_id, 1) = nvl(s2.party_id,1) ) ) OR ( s1.party_id = s2.party_id) )
1587: and s2.batch_id = p_batch_id and s1.CONTACT_OSR < s2.CONTACT_OSR
1588: and (