22/09/2021 23:46:09  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Vacación MÉTODO->SelectPersonalNoReintegroVacacion ERROR->Invalid query: ERROR:  syntax error at or near ")"
LINE 5:             ELSE 1) AS status_efectivo         
                          ^
Whole query: 
					 SELECT *,
					        (CASE WHEN fecreivac>'2021-09-30'::date THEN 3
							     WHEN fecreivac<='2021-09-30'::date THEN 4
							     ELSE 1) AS status_efectivo								 
					   FROM sno_vacacpersonal 
					  INNER JOIN sno_personalnomina ON sno_personalnomina.codemp = sno_vacacpersonal.codemp
											       AND sno_personalnomina.codper = sno_vacacpersonal.codper
					  WHERE sno_vacacpersonal.codemp='0001' 
						AND sno_vacacpersonal.fecdisvac < '2021-09-16'
						AND sno_vacacpersonal.fecpagvac < '2021-09-16'
						AND sno_vacacpersonal.stavac=2
						AND sno_personalnomina.codnom='1003'