From: Eric Mc Sween <eric.mcsween@auf.org>
Date: Mon, 9 Sep 2013 16:30:27 +0000 (-0400)
Subject: Utiliser le cumul ENGAGEMENT au lieu de ENGAGE
X-Git-Url: http://git.auf.org/?p=auf_coda_additions.git;a=commitdiff_plain;h=f449635c5caf861c46ce2bec8c59c1b29f63fac7;ds=sidebyside

Utiliser le cumul ENGAGEMENT au lieu de ENGAGE
---

diff --git a/db/procedures/auf_p_intero_cumul_dep_rec.sql b/db/procedures/auf_p_intero_cumul_dep_rec.sql
index 2569f48..ba4cbac 100644
--- a/db/procedures/auf_p_intero_cumul_dep_rec.sql
+++ b/db/procedures/auf_p_intero_cumul_dep_rec.sql
@@ -124,11 +124,11 @@ WHERE
     AND imp.grpcode LIKE @groupe
 GROUP BY el3
 
--- ENGAGE --
+-- ENGAGEMENT --
 INSERT INTO #cumuls
 SELECT
     el3,
-    'ENGAGE' typecumul,
+    'ENGAGEMENT' typecumul,
     SUM(full_value) mont
 FROM oas_balance, oas_grplist imp
 WHERE
@@ -138,7 +138,7 @@ WHERE
     AND period BETWEEN 1 AND @periode
     AND curcode = 'EUR'
     AND repbasis = 5
-    AND balcode = 'ENGAGE'
+    AND balcode = 'ENGAGEMENT'
     AND el1 NOT LIKE '4%'
     AND el1 NOT LIKE '96%'
     AND el1 NOT LIKE '97%'
@@ -194,7 +194,7 @@ FROM
         FROM #cumuls
     ) engages
         ON cumul.el3 = engages.el3
-        AND engages.typecumul = 'ENGAGE'
+        AND engages.typecumul = 'ENGAGEMENT'
     LEFT JOIN  oas_element e
         ON cumul.el3 = e.code
         AND e.cmpcode = 'AUF'