APPS.HZ_MATCH_RULE_51 dependencies on HZ_DUP_SET_PARTIES

Line 1868: SELECT 1 INTO l_tmp FROM HZ_DUP_SET_PARTIES

1864: VALUES (l_search_ctx_id,H_SCORES(l_party_id).PARTY_ID,H_SCORES(l_party_id).TOTAL_SCORE);
1865: x_num_matches := x_num_matches+1;
1866: ELSE
1867: BEGIN
1868: SELECT 1 INTO l_tmp FROM HZ_DUP_SET_PARTIES
1869: WHERE DUP_PARTY_ID = H_SCORES(l_party_id).PARTY_ID
1870: AND DUP_SET_BATCH_ID = p_dup_batch_id
1871: AND ROWNUM=1;
1872: EXCEPTION

Line 1879: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

1875: l_merge_flag := 'Y';
1876: ELSE
1877: l_merge_flag := 'N';
1878: END IF;
1879: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
1880: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
1881: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
1882: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
1883: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,

Line 2722: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

2718: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2719: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2720: hz_utility_pub.user_id);
2721:
2722: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
2723: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
2724: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2725: VALUES (p_party_id,x_dup_set_id,0,0,
2726: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,