APPS.HZ_ACCT_MERGE_UTIL SQL Statements

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

Line: 23

    g_cust_list.DELETE;

Line: 24

    g_site_list.DELETE;

Line: 25

    g_addr_list.DELETE;

Line: 27

      SELECT distinct customer_id, duplicate_id
      FROM ra_customer_merges
      WHERE set_number = p_set_num
      AND request_id = p_request_id
      AND process_flag = 'N' ) LOOP
     g_cust_list(CUST.duplicate_id) := CUST.customer_id;

Line: 35

      SELECT distinct customer_address_id, duplicate_address_id
      FROM ra_customer_merges
      WHERE set_number = p_set_num
      AND request_id = p_request_id
      AND process_flag = 'N' ) LOOP
     g_addr_list(ADDR.duplicate_address_id) := ADDR.customer_address_id;

Line: 44

      SELECT distinct customer_site_id, duplicate_site_id
      FROM ra_customer_merges
      WHERE set_number = p_set_num
      AND request_id = p_request_id
      AND process_flag = 'N' ) LOOP
     g_site_list(SITE.duplicate_site_id) := SITE.customer_site_id;