03/07/2021 22:28:41  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_aportepatronal_personal ERROR->Invalid query: ERROR:  column s.sueintcon does not exist
LINE 20:         AND s.sueintcon=1
                     ^
HINT:  Perhaps you meant to reference the column "c.sueintcon".
Whole query: SELECT sno_personal.codper,
		                sno_personal.cedper, 
						sno_personal.apeper, 
						sno_personal.nomper, 
						MAX(sno_hpersonalnomina.sueintper) as sueintper, 
						SUM(sno_hpersonalnomina.sueper) as sueper, 
						sno_hpersonalnomina.codnom, 
						       (SELECT SUM(valsal)  		 FROM sno_hsalida      	WHERE sno_hsalida.codconc IN ('')
									             AND sno_hpersonalnomina.codemp = sno_hsalida.codemp    		  AND sno_hpersonalnomina.codnom = sno_hsalida.codnom    		  AND sno_hpersonalnomina.anocur = sno_hsalida.anocur    		  AND sno_hpersonalnomina.codperi = sno_hsalida.codperi    		  AND sno_hpersonalnomina.codper = sno_hsalida.codper) as sueintbanavih,        (SELECT SUM(valsal) 		   FROM sno_hsalida    	  WHERE (sno_hsalida.tipsal='A' OR sno_hsalida.tipsal='V1' OR sno_hsalida.tipsal='W1')
				           AND sno_hpersonalnomina.codemp = sno_hsalida.codemp    		AND sno_hpersonalnomina.codnom = sno_hsalida.codnom    		AND sno_hpersonalnomina.anocur = sno_hsalida.anocur    		AND sno_hpersonalnomina.codperi = sno_hsalida.codperi    		AND sno_hpersonalnomina.codper = sno_hsalida.codper) as ingresos, 
				      
				    (SELECT SUM(s.valsal)
				       FROM sno_hsalida s 
					 INNER JOIN sno_hconcepto c ON c.codemp=s.codemp 
											   AND c.codnom=s.codnom 
											   AND c.anocur=s.anocur 
											   AND c.codperi=s.codperi 
											   AND c.codconc=s.codconc 
					 WHERE (s.tipsal='A' OR s.tipsal='V1' OR s.tipsal='W1')
					   AND s.sueintcon=1
					   AND s.valsal<>0
					   AND sno_hpersonalnomina.codemp = s.codemp
					   AND sno_hpersonalnomina.codnom = s.codnom
					   AND sno_hpersonalnomina.anocur = s.anocur
					   AND sno_hpersonalnomina.codperi = s.codperi
					   AND sno_hpersonalnomina.codper = s.codper
					) as sueldo_integral,
					
					(SELECT SUM(s.valsal)
				       FROM sno_hsalida s 
					 INNER JOIN sno_hconcepto c ON c.codemp=s.codemp 
											   AND c.codnom=s.codnom 
											   AND c.anocur=s.anocur 
											   AND c.codperi=s.codperi 
											   AND c.codconc=s.codconc 
					 WHERE (s.tipsal='A' OR s.tipsal='V1' OR s.tipsal='W1')
					   AND s.persalnor=1
					   AND s.valsal<>0
					   AND sno_hpersonalnomina.codemp = s.codemp
					   AND sno_hpersonalnomina.codnom = s.codnom
					   AND sno_hpersonalnomina.anocur = s.anocur
					   AND sno_hpersonalnomina.codperi = s.codperi
					   AND sno_hpersonalnomina.codper = s.codper
					) as sueldo_normal,
					
					
				       (SELECT SUM(valsal) 		   FROM sno_hsalida    	  WHERE (sno_hsalida.tipsal='P1' OR sno_hsalida.tipsal='V3' OR sno_hsalida.tipsal='W3' OR sno_hsalida.tipsal='Q1') 
				 AND sno_hsalida.valsal<>0  AND sno_hsalida.codconc='0000008010'            AND sno_hpersonalnomina.codemp = sno_hsalida.codemp    		AND sno_hpersonalnomina.codnom = sno_hsalida.codnom    		AND sno_hpersonalnomina.anocur = sno_hsalida.anocur    		AND sno_hpersonalnomina.codperi = sno_hsalida.codperi    		AND sno_hpersonalnomina.codper = sno_hsalida.codper) as personal,        (SELECT SUM(valsal) 		   FROM sno_hsalida    	  WHERE (sno_hsalida.tipsal='P2' OR sno_hsalida.tipsal='V4' OR sno_hsalida.tipsal='W4' OR sno_hsalida.tipsal='Q2')
				 AND sno_hsalida.valsal<>0  AND sno_hsalida.codconc='0000008010'            AND sno_hpersonalnomina.codemp = sno_hsalida.codemp    		AND sno_hpersonalnomina.codnom = sno_hsalida.codnom    		AND sno_hpersonalnomina.anocur = sno_hsalida.anocur    		AND sno_hpersonalnomina.codperi = sno_hsalida.codperi    		AND sno_hpersonalnomina.codper = sno_hsalida.codper) as patron   FROM sno_personal, sno_hpersonalnomina, sno_hsalida, sno_hperiodo  WHERE sno_hpersonalnomina.codemp='0001'    AND sno_hpersonalnomina.codnom>='1000'    AND sno_hpersonalnomina.codnom<='1000'    AND sno_hpersonalnomina.anocur>='2021'    AND sno_hpersonalnomina.anocur<='2021'    AND sno_hpersonalnomina.codperi>='009'    AND sno_hpersonalnomina.codperi<='010'    AND substr(CAST(sno_hperiodo.fecdesper AS char(10)),6,2)>='05'    AND substr(CAST(sno_hperiodo.fecdesper AS char(10)),6,2)<='05'    AND (sno_hpersonalnomina.staper='1' OR sno_hpersonalnomina.staper='2')  AND sno_hsalida.codnom>='1000'  AND sno_hsalida.codnom<='1000'  AND sno_hsalida.anocur>='2021'  AND sno_hsalida.anocur<='2021'  AND sno_hsalida.anocur<='2021'  AND sno_hsalida.codperi>='009'  AND substr(CAST(sno_hperiodo.fecdesper AS char(10)),6,2)>='05'  AND substr(CAST(sno_hperiodo.fecdesper AS char(10)),6,2)<='05'  AND sno_hsalida.valsal<>0  AND sno_hsalida.codconc='0000008010'    AND sno_hpersonalnomina.codemp = sno_hsalida.codemp    AND sno_hpersonalnomina.codnom = sno_hsalida.codnom    AND sno_hpersonalnomina.anocur = sno_hsalida.anocur    AND sno_hpersonalnomina.codperi = sno_hsalida.codperi    AND sno_hpersonalnomina.codper = sno_hsalida.codper    AND sno_hsalida.codemp = sno_hperiodo.codemp    AND sno_hsalida.codnom = sno_hperiodo.codnom    AND sno_hsalida.anocur = sno_hperiodo.anocur    AND sno_hsalida.codperi = sno_hperiodo.codperi    AND sno_personal.codemp = sno_hpersonalnomina.codemp    AND sno_personal.codper = sno_hpersonalnomina.codper  GROUP BY sno_hpersonalnomina.codemp, sno_hpersonalnomina.codnom, sno_hpersonalnomina.codper, sno_personal.codper, 
				  		   sno_hpersonalnomina.anocur, sno_hpersonalnomina.codperi, sno_personal.cedper, sno_personal.apeper, 
						   sno_personal.nomper, sno_hpersonalnomina.codsubnom,sno_hperiodo.fecdesper    ORDER BY sno_personal.codper 

03/07/2021 22:28:59  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_aportepatronal_personal ERROR->Invalid query: ERROR:  operator does not exist: character = integer
LINE 37:         AND c.persalnor=1
                                ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
Whole query: SELECT sno_personal.codper,
		                sno_personal.cedper, 
						sno_personal.apeper, 
						sno_personal.nomper, 
						MAX(sno_hpersonalnomina.sueintper) as sueintper, 
						SUM(sno_hpersonalnomina.sueper) as sueper, 
						sno_hpersonalnomina.codnom, 
						       (SELECT SUM(valsal)  		 FROM sno_hsalida      	WHERE sno_hsalida.codconc IN ('')
									             AND sno_hpersonalnomina.codemp = sno_hsalida.codemp    		  AND sno_hpersonalnomina.codnom = sno_hsalida.codnom    		  AND sno_hpersonalnomina.anocur = sno_hsalida.anocur    		  AND sno_hpersonalnomina.codperi = sno_hsalida.codperi    		  AND sno_hpersonalnomina.codper = sno_hsalida.codper) as sueintbanavih,        (SELECT SUM(valsal) 		   FROM sno_hsalida    	  WHERE (sno_hsalida.tipsal='A' OR sno_hsalida.tipsal='V1' OR sno_hsalida.tipsal='W1')
				           AND sno_hpersonalnomina.codemp = sno_hsalida.codemp    		AND sno_hpersonalnomina.codnom = sno_hsalida.codnom    		AND sno_hpersonalnomina.anocur = sno_hsalida.anocur    		AND sno_hpersonalnomina.codperi = sno_hsalida.codperi    		AND sno_hpersonalnomina.codper = sno_hsalida.codper) as ingresos, 
				      
				    (SELECT SUM(s.valsal)
				       FROM sno_hsalida s 
					 INNER JOIN sno_hconcepto c ON c.codemp=s.codemp 
											   AND c.codnom=s.codnom 
											   AND c.anocur=s.anocur 
											   AND c.codperi=s.codperi 
											   AND c.codconc=s.codconc 
					 WHERE (s.tipsal='A' OR s.tipsal='V1' OR s.tipsal='W1')
					   AND c.sueintcon=1
					   AND s.valsal<>0
					   AND sno_hpersonalnomina.codemp = s.codemp
					   AND sno_hpersonalnomina.codnom = s.codnom
					   AND sno_hpersonalnomina.anocur = s.anocur
					   AND sno_hpersonalnomina.codperi = s.codperi
					   AND sno_hpersonalnomina.codper = s.codper
					) as sueldo_integral,
					
					(SELECT SUM(s.valsal)
				       FROM sno_hsalida s 
					 INNER JOIN sno_hconcepto c ON c.codemp=s.codemp 
											   AND c.codnom=s.codnom 
											   AND c.anocur=s.anocur 
											   AND c.codperi=s.codperi 
											   AND c.codconc=s.codconc 
					 WHERE (s.tipsal='A' OR s.tipsal='V1' OR s.tipsal='W1')
					   AND c.persalnor=1
					   AND s.valsal<>0
					   AND sno_hpersonalnomina.codemp = s.codemp
					   AND sno_hpersonalnomina.codnom = s.codnom
					   AND sno_hpersonalnomina.anocur = s.anocur
					   AND sno_hpersonalnomina.codperi = s.codperi
					   AND sno_hpersonalnomina.codper = s.codper
					) as sueldo_normal,
					
					
				       (SELECT SUM(valsal) 		   FROM sno_hsalida    	  WHERE (sno_hsalida.tipsal='P1' OR sno_hsalida.tipsal='V3' OR sno_hsalida.tipsal='W3' OR sno_hsalida.tipsal='Q1') 
				 AND sno_hsalida.valsal<>0  AND sno_hsalida.codconc='0000008010'            AND sno_hpersonalnomina.codemp = sno_hsalida.codemp    		AND sno_hpersonalnomina.codnom = sno_hsalida.codnom    		AND sno_hpersonalnomina.anocur = sno_hsalida.anocur    		AND sno_hpersonalnomina.codperi = sno_hsalida.codperi    		AND sno_hpersonalnomina.codper = sno_hsalida.codper) as personal,        (SELECT SUM(valsal) 		   FROM sno_hsalida    	  WHERE (sno_hsalida.tipsal='P2' OR sno_hsalida.tipsal='V4' OR sno_hsalida.tipsal='W4' OR sno_hsalida.tipsal='Q2')
				 AND sno_hsalida.valsal<>0  AND sno_hsalida.codconc='0000008010'            AND sno_hpersonalnomina.codemp = sno_hsalida.codemp    		AND sno_hpersonalnomina.codnom = sno_hsalida.codnom    		AND sno_hpersonalnomina.anocur = sno_hsalida.anocur    		AND sno_hpersonalnomina.codperi = sno_hsalida.codperi    		AND sno_hpersonalnomina.codper = sno_hsalida.codper) as patron   FROM sno_personal, sno_hpersonalnomina, sno_hsalida, sno_hperiodo  WHERE sno_hpersonalnomina.codemp='0001'    AND sno_hpersonalnomina.codnom>='1000'    AND sno_hpersonalnomina.codnom<='1000'    AND sno_hpersonalnomina.anocur>='2021'    AND sno_hpersonalnomina.anocur<='2021'    AND sno_hpersonalnomina.codperi>='009'    AND sno_hpersonalnomina.codperi<='010'    AND substr(CAST(sno_hperiodo.fecdesper AS char(10)),6,2)>='05'    AND substr(CAST(sno_hperiodo.fecdesper AS char(10)),6,2)<='05'    AND (sno_hpersonalnomina.staper='1' OR sno_hpersonalnomina.staper='2')  AND sno_hsalida.codnom>='1000'  AND sno_hsalida.codnom<='1000'  AND sno_hsalida.anocur>='2021'  AND sno_hsalida.anocur<='2021'  AND sno_hsalida.anocur<='2021'  AND sno_hsalida.codperi>='009'  AND substr(CAST(sno_hperiodo.fecdesper AS char(10)),6,2)>='05'  AND substr(CAST(sno_hperiodo.fecdesper AS char(10)),6,2)<='05'  AND sno_hsalida.valsal<>0  AND sno_hsalida.codconc='0000008010'    AND sno_hpersonalnomina.codemp = sno_hsalida.codemp    AND sno_hpersonalnomina.codnom = sno_hsalida.codnom    AND sno_hpersonalnomina.anocur = sno_hsalida.anocur    AND sno_hpersonalnomina.codperi = sno_hsalida.codperi    AND sno_hpersonalnomina.codper = sno_hsalida.codper    AND sno_hsalida.codemp = sno_hperiodo.codemp    AND sno_hsalida.codnom = sno_hperiodo.codnom    AND sno_hsalida.anocur = sno_hperiodo.anocur    AND sno_hsalida.codperi = sno_hperiodo.codperi    AND sno_personal.codemp = sno_hpersonalnomina.codemp    AND sno_personal.codper = sno_hpersonalnomina.codper  GROUP BY sno_hpersonalnomina.codemp, sno_hpersonalnomina.codnom, sno_hpersonalnomina.codper, sno_personal.codper, 
				  		   sno_hpersonalnomina.anocur, sno_hpersonalnomina.codperi, sno_personal.cedper, sno_personal.apeper, 
						   sno_personal.nomper, sno_hpersonalnomina.codsubnom,sno_hperiodo.fecdesper    ORDER BY sno_personal.codper