APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_SRCH_CONTACTS

Line 370: INSERT INTO HZ_SRCH_CONTACTS (

366: END LOOP;
367: SAVEPOINT pop_contacts;
368: BEGIN
369: FORALL I in H_P_CONTACT_OSR.FIRST..H_P_CONTACT_OSR.LAST
370: INSERT INTO HZ_SRCH_CONTACTS (
371: TX22, PARTY_OS, PARTY_OSR, CONTACT_OS, CONTACT_OSR, NEW_PARTY_FLAG, BATCH_ID, INT_ROW_ID, PARTY_ID , TX2, TX23
372: ) VALUES (
373: 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)
374: );

Line 656: INSERT INTO HZ_SRCH_CONTACTS (

652: END LOOP;
653: SAVEPOINT pop_contacts_int;
654: BEGIN
655: FORALL I in H_P_CONTACT_OS.FIRST..H_P_CONTACT_OS.LAST
656: INSERT INTO HZ_SRCH_CONTACTS (
657: TX22, PARTY_OS, PARTY_OSR, CONTACT_OS, CONTACT_OSR, BATCH_ID, INT_ROW_ID , TX2, TX23
658: ) VALUES (
659: 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)
660: );

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

1065: decode(instrb(s2.TX22,s1.TX22),1,10,
1066: 0
1067: )
1068: score
1069: from hz_imp_dup_parties h1, HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1070: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1071: 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
1072: and (
1073: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1268: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2

1264: score , s1.party_osr, s1.party_os, p_batch_id,'CONTACTS', s1.ORG_CONTACT_ID, s1.CONTACT_OSR, s1.CONTACT_OS,
1265: s2.ORG_CONTACT_ID
1266: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1267: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1268: from HZ_SRCH_CONTACTS s1, HZ_STAGED_CONTACTS s2
1269: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1270: and s1.party_id = s2.party_id
1271: and (
1272: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

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

1480: decode(instrb(s2.TX22,s1.TX22),1,10,
1481: 0
1482: )
1483: score
1484: from hz_int_dup_results h1, HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2
1485: where
1486: s1.party_osr = h1.f_osr and s2.party_osr = h1.t_osr and h1.batch_id = p_batch_id
1487: and s1.party_osr between from_osr and to_osr
1488: and (

Line 1630: from HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2

1626: )
1627: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1628: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1629: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1630: from HZ_SRCH_CONTACTS s1, HZ_SRCH_CONTACTS s2
1631: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1632: 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) )
1633: and s2.batch_id = p_batch_id and s1.CONTACT_OSR < s2.CONTACT_OSR
1634: and (