APPS.HZ_DQM_SEARCH_UTIL dependencies on HZ_MATCH_RULE_SECONDARY

Line 532: from hz_match_rule_secondary ms, hz_secondary_trans st

528: where match_rule_id = p_match_rule_id
529: and mp.primary_attribute_id = pt.primary_attribute_id
530: union
531: select function_id
532: from hz_match_rule_secondary ms, hz_secondary_trans st
533: where match_rule_id = p_match_rule_id
534: and ms.secondary_attribute_id = st.secondary_attribute_id
535: )
536: and staged_flag <> 'Y'

Line 621: from hz_match_rule_secondary

617: and party_id = TX.party_id;
618: END LOOP;
619: ELSIF ( l_rule_purpose = 'D') THEN
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)