APPS.HZ_DQM_SEARCH_UTIL dependencies on HZ_PARTIES

Line 263: 'SELECT p.party_id FROM HZ_PARTIES p '||

259: ) IS
260: l_sqlstr VARCHAR2(4000);
261: BEGIN
262: l_sqlstr := 'DELETE FROM HZ_DQM_PARTIES_GT m WHERE NOT EXISTS ('||
263: 'SELECT p.party_id FROM HZ_PARTIES p '||
264: 'WHERE p.party_id = m.party_id AND '||
265: p_subset_defn || ') AND SEARCH_CONTEXT_ID = :ctxid';
266: EXECUTE IMMEDIATE l_sqlstr USING p_search_ctx_id;
267: EXCEPTION

Line 593: l_party_rec HZ_PARTIES%ROWTYPE;

589: l_quality_weight NUMBER;
590: l_quality_score NUMBER;
591: l_final_score NUMBER ;
592: l_rule_purpose VARCHAR2(1);
593: l_party_rec HZ_PARTIES%ROWTYPE;
594: l_mms NUMBER;
595: BEGIN
596: l_quality_weight := hz_dqm_quality_uh_pkg.get_quality_weighting(p_match_rule_id);
597: IF (l_quality_weight > 0) THEN

Line 609: from HZ_PARTIES

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
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;

Line 628: from HZ_PARTIES

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
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));