DBA Data[Home] [Help]

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)