APPS.HZ_ORGANIZATION_BO_PUB dependencies on HZ_MATCHED_PARTIES_GT

Line 2282: FROM hz_matched_parties_gt mpg, hz_parties p

2278: then
2279: l_tmp_score := l_match_score;
2280: begin
2281: SELECT score, party_name into l_match_score, l_party_name
2282: FROM hz_matched_parties_gt mpg, hz_parties p
2283: WHERE mpg.party_id = p.party_id
2284: and mpg.party_id = l_party_id
2285: and mpg.search_context_id = l_search_ctx_id
2286: and rownum = 1;