1 2 3 4 5 6 7 8 9 10 11 12
|
SELECT A.MATRICULE, A.NOM, A.PRENOM, N.IDDIVISION, N.IDSECTEUR,N.IDGROUPEGINQ, C.codeSpecialiteOperationnelle, c.tri,T.DATEDEBUT,A.DATESTAGETUTEUR, F.TAUX,J.IDGROUPEPLANNING
FROM FRIENDLY_PNC A LEFT JOIN FRIENDLY_TUTEUR T ON A.MATRICULE = T.MATRICULE , FRIENDLY_FONCTION C, FRIENDLY_GROUPE_GINQ D, FRIENDLY_TAUX_UTILISATION_PN F, FRIENDLY_GROUPE_PLANNING J,FRIENDLY_GINQ N
WHERE A.MATRICULE = C.MATRICULE AND A.MATRICULE = D.MATRICULE
AND (A.STAGETUTEUR ='1' OR A.DATESTAGETUTEUR<>to_date('3000-12-31','YYYY/MM/DD'))
AND D.DATEDEBUT <= to_date(SYSDATE,'DD/MM/YY') AND (D.DATEFIN IS NULL OR D.DATEFIN >=to_date(SYSDATE,'DD/MM/YY'))
AND A.MATRICULE = F.MATRICULE AND D.IDGROUPEGINQ = N.IDGROUPEGINQ AND A.MATRICULE = J.MATRICULE
AND c.DATEDEBUT <= to_date(SYSDATE,'DD/MM/YY') AND c.DATEFIN >= to_date(SYSDATE,'DD/MM/YY')
AND F.DATEDEBUT <= to_date(SYSDATE,'DD/MM/YY') AND F.DATEFIN >= to_date(SYSDATE,'DD/MM/YY')
AND J.DATEDEBUT <= to_date(SYSDATE,'DD/MM/YY') AND J.DATEFIN >= to_date(SYSDATE,'DD/MM/YY')
OR T.DATEDEBUT IS NOT NULL AND ((A.DATEFINDEFINCONTRAT > sysdate or A.DATEFINDEFINCONTRAT is null)
AND (A.DATEDEBUTDEFINCONTRAT > sysdate or A.DATEDEBUTDEFINCONTRAT is null)) order by IDGROUPEGINQ,tri, NOM |
Partager