APPS.HZ_DQM_SEARCH_UTIL dependencies on HZ_MATCHED_PARTIES_GT

Line 605: from hz_matched_parties_gt

601:
602: IF ( l_rule_purpose = 'S') THEN
603: FOR TX IN (
604: select party_id, score
605: from hz_matched_parties_gt
606: where search_context_id = p_srch_ctx_id)
607: LOOP
608: select * into l_party_rec
609: from HZ_PARTIES

Line 614: update hz_matched_parties_gt

610: where party_id = TX.party_id;
611: l_quality_score := hz_dqm_quality_uh_pkg.get_quality_score(p_match_rule_id, l_party_rec);
612: l_score := TX.score;
613: l_final_score := (l_score * ( 100 - l_quality_weight) + l_quality_score * l_quality_weight)/ 100;
614: update hz_matched_parties_gt
615: set score = l_final_score
616: where search_context_id = p_srch_ctx_id
617: and party_id = TX.party_id;
618: END LOOP;

Line 624: from hz_matched_parties_gt

620: select sum(score) into l_mms
621: from hz_match_rule_secondary
622: where match_rule_id = p_match_rule_id;
623: FOR TX IN (select party_id, score
624: from hz_matched_parties_gt
625: where search_context_id = p_srch_ctx_id)
626: LOOP
627: select * into l_party_rec
628: from HZ_PARTIES

Line 633: update hz_matched_parties_gt

629: where party_id = TX.party_id;
630: l_score := TX.score;
631: l_quality_score := hz_dqm_quality_uh_pkg.get_quality_score(p_match_rule_id, l_party_rec);
632: l_final_score := (l_score - (l_score * l_quality_weight)/100 + (l_quality_score * l_quality_weight* l_mms)/(100*100));
633: update hz_matched_parties_gt
634: set score = l_final_score
635: where search_context_id = p_srch_ctx_id
636: and party_id = TX.party_id;
637: END LOOP;