10/06/2021 17:56:39  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Anulacion MÉTODO->uf_insert_dt_solicitud_anulada ERROR->Invalid query: 
Whole query: 

10/06/2021 17:56:40  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Anulacion MÉTODO->uf_insert_dt_solicitud_anulada ERROR->Invalid query: 
Whole query: 

10/06/2021 18:27:59  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_declaracion_xml_cabecera ERROR->Invalid query: ERROR:  syntax error at or near "SELECT"
LINE 36:     SELECT sno_personal.codper, MAX(sno_personal.rifper) AS ...
             ^
Whole query:  SELECT '' AS codper, pro.rifpro, ben.rifben,dt.numfac AS numrecdoc, dt.numcon AS numref,
						 (dt.cmp_monobjret) as baseimp,
						  ded.codconret ,ded.porded,ded.codded, 
						  'CXP' AS procedencia, fecemisol AS fecope,sol.numsol 
					FROM scb_cmp_ret cmp
					INNER JOIN scb_dt_cmp_ret dt ON cmp.codemp = dt.codemp
									AND cmp.codret = dt.codret
									AND cmp.numcom = dt.numcom
									AND cmp.tipsolpag = dt.tipsolpag
					INNER JOIN cxp_solicitudes sol ON dt.codemp = sol.codemp
									  AND dt.numsop = sol.numsol
					INNER JOIN sigesp_deducciones ded ON ded.codemp=dt.codemp
									 AND ded.codded=dt.cmp_codret
					LEFT JOIN rpc_proveedor pro ON cmp.cmp_codpro=pro.cod_pro 
									   AND cmp.cmp_tipproben='P'
					LEFT JOIN rpc_beneficiario ben ON cmp.cmp_cedbene=ben.ced_bene 
									  AND cmp.cmp_tipproben='B' 
					WHERE cmp.codret='0000000006'
				     AND cmp.codemp = '0001' 
					 AND ded.islr = 1				 
					 AND sol.estprosol NOT IN ('A','N')
					 AND cmp.estcmpret<>0
					 AND (sol.tipsolpag ='SOPA' OR sol.tipsolpag ='FOAN' OR sol.tipsolpag ='FOAV' OR sol.tipsolpag ='LIQA')
						  AND sol.fecemisol>='2021-05-01' AND sol.fecemisol<='2021-05-31' AND ( sol.codsuc IN (
														SELECT p.codintper 
														FROM sss_permisos_internos p 
														INNER JOIN cxc_sucursales suc ON suc.codsuc = p.codintper
														WHERE codsis='CXC'
														  AND codusu='ADMINISTRADOR'
													)
								  OR sol.codsuc=''
								  OR sol.codsuc IS NULL
							   )	
						     
						 
				SELECT sno_personal.codper, MAX(sno_personal.rifper) AS rifpro,'' AS rifben,'0' AS numrecdoc,'' AS numref, 
								/*SUM(sno_hsalida.valsal) as baseimp*/
								SUM(CASE WHEN sno_personalisr.porisr<>0 THEN abs(sno_hsalida.valsal)*100/sno_personalisr.porisr ELSE 0 END ) AS baseimp,
						 	   MAX(sno_personalisr.codconret) AS codconret, 
							   MAX(sno_personalisr.porisr) AS porded, sno_personalisr.codisr AS codded, 
							   'SNO' AS procedencia, MAX(sno_hperiodo.fechasper) AS fecope,'' as numsol   FROM sno_hsalida, sno_personalisr, sno_personal, sno_hperiodo,sno_hconcepto  WHERE sno_hsalida.codemp = '0001'    AND SUBSTR(sno_hperiodo.fecdesper,1,4) = '2021'    AND SUBSTR(sno_hperiodo.fecdesper,6,2) = '05'    AND sno_personalisr.codisr = '05'     AND sno_hconcepto.aplisrcon = 1     AND sno_hsalida.codemp = sno_hconcepto.codemp     AND sno_hsalida.anocur = sno_hconcepto.anocur     AND sno_hsalida.codperi = sno_hconcepto.codperi     AND sno_hsalida.codnom = sno_hconcepto.codnom     AND sno_hsalida.codconc = sno_hconcepto.codconc     AND sno_hsalida.codemp = sno_hperiodo.codemp     AND sno_hsalida.anocur = sno_hperiodo.anocur     AND sno_hsalida.codperi = sno_hperiodo.codperi     AND sno_hsalida.codnom = sno_hperiodo.codnom     AND sno_hsalida.codemp = sno_personalisr.codemp     AND sno_hsalida.codper = sno_personalisr.codper     AND sno_personal.codemp = sno_personalisr.codemp     AND sno_personal.codper = sno_personalisr.codper			    
						  GROUP BY sno_personal.codper, sno_personalisr.codisr  ORDER BY 10, 11 

10/06/2021 18:28:31  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_declaracion_xml_cabecera ERROR->Invalid query: ERROR:  syntax error at or near "SELECT"
LINE 36:     SELECT sno_personal.codper, MAX(sno_personal.rifper) AS ...
             ^
Whole query:  SELECT '' AS codper, pro.rifpro, ben.rifben,dt.numfac AS numrecdoc, dt.numcon AS numref,
						 (dt.cmp_monobjret) as baseimp,
						  ded.codconret ,ded.porded,ded.codded, 
						  'CXP' AS procedencia, fecemisol AS fecope,sol.numsol 
					FROM scb_cmp_ret cmp
					INNER JOIN scb_dt_cmp_ret dt ON cmp.codemp = dt.codemp
									AND cmp.codret = dt.codret
									AND cmp.numcom = dt.numcom
									AND cmp.tipsolpag = dt.tipsolpag
					INNER JOIN cxp_solicitudes sol ON dt.codemp = sol.codemp
									  AND dt.numsop = sol.numsol
					INNER JOIN sigesp_deducciones ded ON ded.codemp=dt.codemp
									 AND ded.codded=dt.cmp_codret
					LEFT JOIN rpc_proveedor pro ON cmp.cmp_codpro=pro.cod_pro 
									   AND cmp.cmp_tipproben='P'
					LEFT JOIN rpc_beneficiario ben ON cmp.cmp_cedbene=ben.ced_bene 
									  AND cmp.cmp_tipproben='B' 
					WHERE cmp.codret='0000000006'
				     AND cmp.codemp = '0001' 
					 AND ded.islr = 1				 
					 AND sol.estprosol NOT IN ('A','N')
					 AND cmp.estcmpret<>0
					 AND (sol.tipsolpag ='SOPA' OR sol.tipsolpag ='FOAN' OR sol.tipsolpag ='FOAV' OR sol.tipsolpag ='LIQA')
						  AND sol.fecemisol>='2021-05-01' AND sol.fecemisol<='2021-05-31' AND ( sol.codsuc IN (
														SELECT p.codintper 
														FROM sss_permisos_internos p 
														INNER JOIN cxc_sucursales suc ON suc.codsuc = p.codintper
														WHERE codsis='CXC'
														  AND codusu='ADMINISTRADOR'
													)
								  OR sol.codsuc=''
								  OR sol.codsuc IS NULL
							   )	
						     
						 
				SELECT sno_personal.codper, MAX(sno_personal.rifper) AS rifpro,'' AS rifben,'0' AS numrecdoc,'' AS numref, 
								/*SUM(sno_hsalida.valsal) as baseimp*/
								SUM(CASE WHEN sno_personalisr.porisr<>0 THEN abs(sno_hsalida.valsal)*100/sno_personalisr.porisr ELSE 0 END ) AS baseimp,  
						
							   MAX(sno_personalisr.codconret) AS codconret, 
							   MAX(sno_personalisr.porisr) AS porded, sno_personalisr.codisr AS codded, 
							   'SNO' AS procedencia, MAX(sno_hperiodo.fechasper) AS fecope,'' as numsol   FROM sno_hsalida, sno_personalisr, sno_personal, sno_hperiodo,sno_hconcepto  WHERE sno_hsalida.codemp = '0001'    AND SUBSTR(sno_hperiodo.fecdesper,1,4) = '2021'    AND SUBSTR(sno_hperiodo.fecdesper,6,2) = '05'    AND sno_personalisr.codisr = '05'     AND sno_hconcepto.aplisrcon = 1     AND sno_hsalida.codemp = sno_hconcepto.codemp     AND sno_hsalida.anocur = sno_hconcepto.anocur     AND sno_hsalida.codperi = sno_hconcepto.codperi     AND sno_hsalida.codnom = sno_hconcepto.codnom     AND sno_hsalida.codconc = sno_hconcepto.codconc     AND sno_hsalida.codemp = sno_hperiodo.codemp     AND sno_hsalida.anocur = sno_hperiodo.anocur     AND sno_hsalida.codperi = sno_hperiodo.codperi     AND sno_hsalida.codnom = sno_hperiodo.codnom     AND sno_hsalida.codemp = sno_personalisr.codemp     AND sno_hsalida.codper = sno_personalisr.codper     AND sno_personal.codemp = sno_personalisr.codemp     AND sno_personal.codper = sno_personalisr.codper			    
						 GROUP BY sno_personal.codper, sno_personalisr.codisr  ORDER BY 10, 11 

10/06/2021 18:29:41  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_declaracion_xml_cabecera ERROR->Invalid query: ERROR:  syntax error at or near "SELECT"
LINE 36:     SELECT sno_personal.codper, MAX(sno_personal.rifper) AS ...
             ^
Whole query:  SELECT '' AS codper, pro.rifpro, ben.rifben,dt.numfac AS numrecdoc, dt.numcon AS numref,
						 (dt.cmp_monobjret) as baseimp,
						  ded.codconret ,ded.porded,ded.codded, 
						  'CXP' AS procedencia, fecemisol AS fecope,sol.numsol 
					FROM scb_cmp_ret cmp
					INNER JOIN scb_dt_cmp_ret dt ON cmp.codemp = dt.codemp
									AND cmp.codret = dt.codret
									AND cmp.numcom = dt.numcom
									AND cmp.tipsolpag = dt.tipsolpag
					INNER JOIN cxp_solicitudes sol ON dt.codemp = sol.codemp
									  AND dt.numsop = sol.numsol
					INNER JOIN sigesp_deducciones ded ON ded.codemp=dt.codemp
									 AND ded.codded=dt.cmp_codret
					LEFT JOIN rpc_proveedor pro ON cmp.cmp_codpro=pro.cod_pro 
									   AND cmp.cmp_tipproben='P'
					LEFT JOIN rpc_beneficiario ben ON cmp.cmp_cedbene=ben.ced_bene 
									  AND cmp.cmp_tipproben='B' 
					WHERE cmp.codret='0000000006'
				     AND cmp.codemp = '0001' 
					 AND ded.islr = 1				 
					 AND sol.estprosol NOT IN ('A','N')
					 AND cmp.estcmpret<>0
					 AND (sol.tipsolpag ='SOPA' OR sol.tipsolpag ='FOAN' OR sol.tipsolpag ='FOAV' OR sol.tipsolpag ='LIQA')
						  AND sol.fecemisol>='2021-05-01' AND sol.fecemisol<='2021-05-31' AND ( sol.codsuc IN (
														SELECT p.codintper 
														FROM sss_permisos_internos p 
														INNER JOIN cxc_sucursales suc ON suc.codsuc = p.codintper
														WHERE codsis='CXC'
														  AND codusu='ADMINISTRADOR'
													)
								  OR sol.codsuc=''
								  OR sol.codsuc IS NULL
							   )	
						     
						 
				SELECT sno_personal.codper, MAX(sno_personal.rifper) AS rifpro,'' AS rifben,'0' AS numrecdoc,'' AS numref, 
								/*SUM(sno_hsalida.valsal) as baseimp*/
								SUM(CASE WHEN sno_personalisr.porisr<>0 THEN abs(sno_hsalida.valsal)*100/sno_personalisr.porisr ELSE 0 END ) AS baseimp,  
						
							   MAX(sno_personalisr.codconret) AS codconret, 
							   MAX(sno_personalisr.porisr) AS porded, sno_personalisr.codisr AS codded, 
							   'SNO' AS procedencia, MAX(sno_hperiodo.fechasper) AS fecope,'' as numsol   FROM sno_hsalida, sno_personalisr, sno_personal, sno_hperiodo,sno_hconcepto  WHERE sno_hsalida.codemp = '0001'    AND SUBSTR(sno_hperiodo.fecdesper,1,4) = '2021'    AND SUBSTR(sno_hperiodo.fecdesper,6,2) = '05'    AND sno_personalisr.codisr = '05'     AND sno_hconcepto.aplisrcon = 1     AND sno_hsalida.codemp = sno_hconcepto.codemp     AND sno_hsalida.anocur = sno_hconcepto.anocur     AND sno_hsalida.codperi = sno_hconcepto.codperi     AND sno_hsalida.codnom = sno_hconcepto.codnom     AND sno_hsalida.codconc = sno_hconcepto.codconc     AND sno_hsalida.codemp = sno_hperiodo.codemp     AND sno_hsalida.anocur = sno_hperiodo.anocur     AND sno_hsalida.codperi = sno_hperiodo.codperi     AND sno_hsalida.codnom = sno_hperiodo.codnom     AND sno_hsalida.codemp = sno_personalisr.codemp     AND sno_hsalida.codper = sno_personalisr.codper     AND sno_personal.codemp = sno_personalisr.codemp     AND sno_personal.codper = sno_personalisr.codper			    
						 GROUP BY sno_personal.codper, sno_personalisr.codisr  ORDER BY 10, 11 

10/06/2021 18:35:26  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_declaracion_xml_cabecera ERROR->Invalid query: ERROR:  syntax error at or near "SELECT"
LINE 36:     SELECT sno_personal.codper, MAX(sno_personal.rifper) AS ...
             ^
Whole query:  SELECT '' AS codper, pro.rifpro, ben.rifben,dt.numfac AS numrecdoc, dt.numcon AS numref,
						 (dt.cmp_monobjret) as baseimp,
						  ded.codconret ,ded.porded,ded.codded, 
						  'CXP' AS procedencia, fecemisol AS fecope,sol.numsol 
					FROM scb_cmp_ret cmp
					INNER JOIN scb_dt_cmp_ret dt ON cmp.codemp = dt.codemp
									AND cmp.codret = dt.codret
									AND cmp.numcom = dt.numcom
									AND cmp.tipsolpag = dt.tipsolpag
					INNER JOIN cxp_solicitudes sol ON dt.codemp = sol.codemp
									  AND dt.numsop = sol.numsol
					INNER JOIN sigesp_deducciones ded ON ded.codemp=dt.codemp
									 AND ded.codded=dt.cmp_codret
					LEFT JOIN rpc_proveedor pro ON cmp.cmp_codpro=pro.cod_pro 
									   AND cmp.cmp_tipproben='P'
					LEFT JOIN rpc_beneficiario ben ON cmp.cmp_cedbene=ben.ced_bene 
									  AND cmp.cmp_tipproben='B' 
					WHERE cmp.codret='0000000006'
				     AND cmp.codemp = '0001' 
					 AND ded.islr = 1				 
					 AND sol.estprosol NOT IN ('A','N')
					 AND cmp.estcmpret<>0
					 AND (sol.tipsolpag ='SOPA' OR sol.tipsolpag ='FOAN' OR sol.tipsolpag ='FOAV' OR sol.tipsolpag ='LIQA')
						  AND sol.fecemisol>='2021-05-01' AND sol.fecemisol<='2021-05-31' AND ( sol.codsuc IN (
														SELECT p.codintper 
														FROM sss_permisos_internos p 
														INNER JOIN cxc_sucursales suc ON suc.codsuc = p.codintper
														WHERE codsis='CXC'
														  AND codusu='ADMINISTRADOR'
													)
								  OR sol.codsuc=''
								  OR sol.codsuc IS NULL
							   )	
						     
						 
				SELECT sno_personal.codper, MAX(sno_personal.rifper) AS rifpro,'' AS rifben,'0' AS numrecdoc,'' AS numref, 
								/*SUM(sno_hsalida.valsal) as baseimp*/
								SUM(CASE WHEN sno_personalisr.porisr<>0 THEN abs(sno_hsalida.valsal)*100/sno_personalisr.porisr ELSE 0 END ) AS baseimp,  
						
							   MAX(sno_personalisr.codconret) AS codconret, 
							   MAX(sno_personalisr.porisr) AS porded, sno_personalisr.codisr AS codded, 
							   'SNO' AS procedencia, MAX(sno_hperiodo.fechasper) AS fecope,'' as numsol   FROM sno_hsalida, sno_personalisr, sno_personal, sno_hperiodo,sno_hconcepto  WHERE sno_hsalida.codemp = '0001'    AND SUBSTR(sno_hperiodo.fecdesper,1,4) = '2021'    AND SUBSTR(sno_hperiodo.fecdesper,6,2) = '05'    AND sno_personalisr.codisr = '05'     AND sno_hconcepto.aplisrcon = 1     AND sno_hsalida.codemp = sno_hconcepto.codemp     AND sno_hsalida.anocur = sno_hconcepto.anocur     AND sno_hsalida.codperi = sno_hconcepto.codperi     AND sno_hsalida.codnom = sno_hconcepto.codnom     AND sno_hsalida.codconc = sno_hconcepto.codconc     AND sno_hsalida.codemp = sno_hperiodo.codemp     AND sno_hsalida.anocur = sno_hperiodo.anocur     AND sno_hsalida.codperi = sno_hperiodo.codperi     AND sno_hsalida.codnom = sno_hperiodo.codnom     AND sno_hsalida.codemp = sno_personalisr.codemp     AND sno_hsalida.codper = sno_personalisr.codper     AND sno_personal.codemp = sno_personalisr.codemp     AND sno_personal.codper = sno_personalisr.codper			    
						 GROUP BY sno_personal.codper, sno_personalisr.codisr  ORDER BY 10, 11