APPS.ISC_DEPOT_PARTY_MERGE_PKG SQL Statements

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

Line: 23

  SELECT merge_reason_code
     INTO   l_merge_reason_code
     FROM   hz_merge_batch
    WHERE  batch_id  = p_batch_id;

Line: 44

    update isc_dr_repair_orders_f
    set customer_id = p_to_fk_id,
        last_update_date = hz_utility_pub.last_update_date,
      	last_updated_by = hz_utility_pub.user_id,
     	last_update_login = hz_utility_pub.last_update_login
    where customer_id = p_from_fk_id;