APPS.HZ_DUP_PVT dependencies on HZ_MATCHED_PARTIES_GT
Line 2265: FROM hz_matched_parties_gt mpg, hz_parties p
2261: cursor get_party_with_highest_score_c is
2262: SELECT party_id, score, party_name
2263: FROM (SELECT mpg.party_id party_id, mpg.score, p.party_name,
2264: RANK() OVER (ORDER BY score desc) rank 2265: FROM hz_matched_parties_gt mpg, hz_parties p 2266: WHERE mpg.party_id = p.party_id
2267: AND mpg.search_context_id = p_search_ctx_id
2268: AND mpg.party_id <> p_new_party_id -- newly created id
2269: ORDER BY p.last_update_date desc)