 BEGIN
 
 -- recupération de l'id_source
-  SELECT INTO the_id_source s.id_source FROM gn_synthese.t_sources s WHERE name_source = 'occtax';
+  SELECT INTO the_id_source s.id_source FROM gn_synthese.t_sources s WHERE name_source ILIKE 'occtax';
   -- récupération des id_counting à partir de l'id_releve
   SELECT INTO the_id_countings pr_occtax.get_id_counting_from_id_releve(NEW.id_releve_occtax::integer);
   IF the_id_countings IS NOT NULL THEN

  counting RECORD;
BEGIN
  -- recupération de l'id_source
  SELECT INTO the_id_source id_source FROM gn_synthese.t_sources WHERE name_source = 'occtax';
  -- suppression dans la synthese
  FOR counting IN SELECT * FROM pr_occtax.cor_counting_occtax WHERE id_occurrence_occtax = OLD.id_occurrence_occtax LOOP
    SELECT INTO the_id_synthese id_synthese

  occurrence RECORD;
  counting RECORD;
BEGIN
  SELECT INTO the_id_source id_source FROM gn_synthese.t_sources WHERE name_source ILIKE 'occtax';
    FOR occurrence IN SELECT * FROM pr_occtax.t_occurrences_occtax WHERE id_releve_occtax = OLD.id_releve_occtax LOOP
      FOR counting IN SELECT * FROM pr_occtax.cor_counting_occtax WHERE id_occurrence_occtax = occurrence.id_occurrence_occtax LOOP
        SELECT INTO the_id_synthese id_synthese
