SELECT
 (T_SAL.MatriculeSalarie || ' ' || NVL(T_SAL.Nom, ' ') || ' '  || NVL(T_SAL.Prenom, ' ') ) as Col1,
 'Date de fin de contrat : ' || TO_CHAR(T_HST_CONTRAT.DateFinContrat) as Col2
FROM
  T_PAI,
  T_SAL
  LEFT OUTER JOIN T_HST_CONTRAT ON T_HST_CONTRAT.NumSalarie=T_SAL.SA_CompteurNumero
                  AND T_HST_CONTRAT.InfoEnCours=1
  LEFT OUTER JOIN T_NATUREDECONTRAT ON T_HST_CONTRAT.CodeNatureDeContrat = T_NATUREDECONTRAT.Code
Where  (
            (CURRENT_TIMESTAMP >= NVL(-%NbJoursAvant%,0) + T_HST_CONTRAT.DateFinContrat)
        and (CURRENT_TIMESTAMP <= NVL(%NbJoursApres%,0) + T_HST_CONTRAT.DateFinContrat)
	      and (T_NATUREDECONTRAT.NatureDeContrat = 1)   )

Order by T_SAL.MatriculeSalarie