APPS.ARH_DQM_PKG SQL Statements

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

Line: 1006

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

Line: 1014

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

Line: 1025

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

Line: 1628

  SELECT party_site_id
    FROM hz_party_sites
   WHERE party_id = p_party_id
     AND identifying_address_flag = 'Y';

Line: 1635

  SELECT b.org_contact_id
    FROM hz_relationships  a,
         hz_org_contacts   b
   WHERE a.object_id        = p_party_id
     AND a.directional_flag = 'F'
     AND a.relationship_id  = b.party_relationship_id
     AND rownum <5
   ORDER BY b.last_update_date;

Line: 1646

  SELECT a.contact_point_id,
         a.last_update_date
    FROM hz_contact_points a
   WHERE a.owner_table_name = 'HZ_PARTIES'
     AND a.owner_table_id   = p_party_id
  UNION ALL
  SELECT a.contact_point_id,
         a.last_update_date
    FROM hz_contact_points a,
         hz_party_sites    b
   WHERE a.owner_table_name = 'HZ_PARTY_SITES'
     AND a.owner_table_id   = b.party_site_id
     AND b.party_id       = p_party_id
  UNION ALL
  SELECT a.contact_point_id,
         a.last_update_date
    FROM hz_contact_points a,
         hz_relationships  b,
         hz_org_contacts   c
   WHERE b.object_id             = p_party_id
     AND b.directional_flag      = 'F'
     AND b.party_id              = a.owner_table_id
     AND a.owner_table_name      = 'HZ_PARTIES'
     AND c.party_relationship_id = b.relationship_id
   ORDER BY last_update_date;

Line: 1677

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

Line: 1685

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

Line: 1694

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