Skip to content
Snippets Groups Projects

Fix #29035 : mettre dans l'indicateur 330 uniquement ceux qui ont un avenant...

Closed Antony Le Courtes requested to merge alc-fix-indicateur330 into b14
1 file
+ 2
1
Compare changes
  • Side-by-side
  • Inline
@@ -4,8 +4,9 @@ WITH has_contrat AS (
intervenant_id
FROM
tbl_contrat
JOIN parametre p on p.nom = 'contrat_regle_franchissement'
WHERE
edite > 0
CASE p.valeur WHEN 'date-retour' THEN signe ELSE edite END > 0
)
SELECT
rownum id,
Loading