APPS.ARH_DQM_SRCH_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 1628

  SELECT party_id,
         score
    FROM hz_matched_parties_gt
   WHERE search_context_id = i_ctx_id
   ORDER BY SCORE;

Line: 1636

  SELECT party_id,
         contact_point_id,
         score
    FROM hz_matched_cpts_gt
   WHERE search_context_id = i_ctx_id
   ORDER BY SCORE;

Line: 1647

  SELECT party_id,
         org_contact_id,
         score
    FROM hz_matched_contacts_gt
   WHERE search_context_id = i_ctx_id
   ORDER BY SCORE;