APPS.HZ_MATCH_RULE_50 dependencies on HZ_DUP_SET_PARTIES

Line 2142: SELECT 1 INTO l_tmp FROM HZ_DUP_SET_PARTIES

2138: VALUES (l_search_ctx_id,H_SCORES(l_party_id).PARTY_ID,H_SCORES(l_party_id).TOTAL_SCORE);
2139: x_num_matches := x_num_matches+1;
2140: ELSE
2141: BEGIN
2142: SELECT 1 INTO l_tmp FROM HZ_DUP_SET_PARTIES
2143: WHERE DUP_PARTY_ID = H_SCORES(l_party_id).PARTY_ID
2144: AND DUP_SET_BATCH_ID = p_dup_batch_id
2145: AND ROWNUM=1;
2146: EXCEPTION

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

2149: l_merge_flag := 'Y';
2150: ELSE
2151: l_merge_flag := 'N';
2152: END IF;
2153: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
2154: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
2155: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2156: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2157: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,

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

2994: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
2995: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
2996: hz_utility_pub.user_id);
2997:
2998: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
2999: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3000: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3001: VALUES (p_party_id,x_dup_set_id,0,0,
3002: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,