15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_reversar_recepcion_documento ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: DELETE FROM cxp_rd WHERE codemp='0001' AND numrecdoc='2019-1000-020-N' AND codtipdoc='00002' AND cod_pro='----------' AND ced_bene='0000000001' 15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1001-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1001-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1002-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1002-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1002-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1002-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1003-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1003-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1003-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1003-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1004-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1004-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1004-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1004-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1006-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1006-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1014-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1014-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:15:53 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1014-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1014-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_reversar_recepcion_documento ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: DELETE FROM cxp_rd WHERE codemp='0001' AND numrecdoc='2019-1000-020-N' AND codtipdoc='00002' AND cod_pro='----------' AND ced_bene='0000000001' 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1001-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1001-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1002-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1002-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1002-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1002-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1003-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1003-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1003-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1003-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1004-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1004-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1004-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1004-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1006-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1006-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1014-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1014-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:16:48 ***** ERROR DE SISTEMA: ***** avelasquez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1014-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1014-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_reversar_recepcion_documento ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: DELETE FROM cxp_rd WHERE codemp='0001' AND numrecdoc='2019-1000-020-N' AND codtipdoc='00002' AND cod_pro='----------' AND ced_bene='0000000001' 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1001-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1001-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1002-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1002-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1002-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1002-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1003-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1003-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1003-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1003-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1004-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1004-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1004-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1004-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1006-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1006-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1014-020-A' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1014-020-A' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:18:46 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 2019-1000-020-N, 00002, 0000000001, ----------) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1014-020-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1014-020-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:44:32 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_reversar_recepcion_documento ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 000030030011000, 00002, ----------, 0200000856) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: DELETE FROM cxp_rd WHERE codemp='0001' AND numrecdoc='000030030011000' AND codtipdoc='00002' AND cod_pro='0200000856' AND ced_bene='----------' 15/10/2019 09:44:32 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 000030030011000, 00002, ----------, 0200000856) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1000-001-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1000-001-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 09:56:26 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_reversar_recepcion_documento ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 000030030011000, 00002, ----------, 0200000856) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: DELETE FROM cxp_rd WHERE codemp='0001' AND numrecdoc='000030030011000' AND codtipdoc='00002' AND cod_pro='0200000856' AND ced_bene='----------' 15/10/2019 09:56:26 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Integración SNO MÉTODO->uf_obtener_data_comprobante ERROR->Invalid query: ERROR: update o delete en «cxp_rd» viola la llave foránea «fk_cxp_dt_s_cxp_rd__c_cxp_rd» en la tabla «cxp_dt_solicitudes» DETAIL: La llave (codemp, numrecdoc, codtipdoc, ced_bene, cod_pro)=(0001, 000030030011000, 00002, ----------, 0200000856) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: SELECT sno_dt_spg.tipnom, sno_dt_spg. codperi, sno_dt_spg.codnom, sno_dt_spg.cod_pro, sno_dt_spg.ced_bene, sno_dt_spg.tipo_destino, sno_dt_spg.descripcion, sno_dt_spg.operacion, sno_dt_spg.estatus, sno_dt_spg.codtipdoc,sno_dt_spg.estrd,sno_dt_spg.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spg, sno_hnomina WHERE sno_dt_spg.codemp='0001' AND sno_dt_spg.codcom='2019-1000-001-N' AND sno_hnomina.codemp = sno_dt_spg.codemp AND sno_hnomina.codnom = sno_dt_spg.codnom AND sno_hnomina.peractnom = sno_dt_spg.codperi UNION SELECT sno_dt_spi.tipnom, sno_dt_spi.codperi, sno_dt_spi.codnom, sno_dt_spi.cod_pro, sno_dt_spi.ced_bene, sno_dt_spi.tipo_destino, sno_dt_spi.descripcion, sno_dt_spi.operacion, sno_dt_spi.estatus, sno_dt_spi.codtipdoc,sno_dt_spi.estrd,sno_dt_spi.estnotdeb, sno_hnomina.cueconnom, sno_hnomina.anocurnom, sno_hnomina.estctaalt FROM sno_dt_spi, sno_hnomina WHERE sno_dt_spi.codemp='0001' AND sno_dt_spi.codcom='2019-1000-001-N' AND sno_dt_spi.codemp = sno_hnomina.codemp AND sno_dt_spi.codnom = sno_hnomina.codnom AND sno_hnomina.peractnom = sno_dt_spi.codperi 15/10/2019 12:06:13 ***** ERROR DE SISTEMA: ***** daguilar ***** CLASE->Calcular Nómina MÉTODO->uf_insert_resumen ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «pk_sno_resumen» DETAIL: Ya existe la llave (codemp, codnom, codper, codperi)=(0001, 1002, 0016555073, 020). Whole query: INSERT INTO sno_resumen (codemp,codnom,codperi,codper,asires,dedres,apoempres,apopatres,priquires,segquires, monnetres) VALUES ('0001','1002','020','0016555073', '0','0','0','0','0','0','0') 15/10/2019 12:06:13 ***** ERROR DE SISTEMA: ***** daguilar ***** CLASE->Calcular Nómina MÉTODO->uf_calcular_sueldo_promedio ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «pk_sno_resumen» DETAIL: Ya existe la llave (codemp, codnom, codper, codperi)=(0001, 1002, 0016555073, 020). Whole query: SELECT (SUM(CASE WHEN sueper IS NULL THEN 0 ELSE sueper END)/COUNT(codper)) AS sueldo FROM sno_hpersonalnomina WHERE codemp='0001' AND codnom='1002' AND codper='0016555073' 15/10/2019 15:11:11 ***** ERROR DE SISTEMA: ***** daguilar ***** ERROR->CONSTANTE CT[0000000002] Nó Válido. Utilizado en el Concepto 0000000002 15/10/2019 15:11:11 ***** ERROR DE SISTEMA: ***** daguilar ***** ERROR->CONSTANTE CT[0000000002] Nó Válido. Utilizado en el Concepto 0000000002 15/10/2019 16:49:08 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Invalid query: ERROR: no existe la columna sno_personal.diasservprevper LINE 1: ... sno_personal.anoservprefijo, sno_personal.codorg,sno_person... ^ Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper, sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa, sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin, sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper, sno_personal.talpanper, sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,sno_personal.diasservprevper, sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, sno_personal.habediusu, sno_personal.feccieedi, (SELECT denger FROM srh_gerencia WHERE srh_gerencia.codemp = sno_personal.codemp AND srh_gerencia.codger = sno_personal.codger ) AS denger, (SELECT desorg FROM srh_organigrama WHERE srh_organigrama.codemp = sno_personal.codemp AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, (SELECT denunivipladin FROM srh_unidadvipladin WHERE srh_unidadvipladin.codemp = sno_personal.codemp AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, (SELECT dentippersss FROM sno_tipopersonalsss WHERE sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss, (SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, (SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, (SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, (SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia WHERE sno_personal.codemp='0001' AND sno_profesion.codemp = sno_personal.codemp AND sno_profesion.codpro = sno_personal.codpro AND sigesp_pais.codpai = sno_personal.codpai AND sigesp_estados.codpai = sno_personal.codpai AND sigesp_estados.codest = sno_personal.codest AND sigesp_municipio.codpai = sno_personal.codpai AND sigesp_municipio.codest = sno_personal.codest AND sigesp_municipio.codmun = sno_personal.codmun AND sigesp_parroquia.codpai = sno_personal.codpai AND sigesp_parroquia.codest = sno_personal.codest AND sigesp_parroquia.codmun = sno_personal.codmun AND sigesp_parroquia.codpar = sno_personal.codpar AND sno_personal.codper ILIKE '%%' AND sno_personal.cedper ILIKE '%21374843%' AND sno_personal.nomper ILIKE '%%' AND sno_personal.apeper ILIKE '%%' AND sno_personal.numexpper ILIKE '%%' AND sno_personal.codper IN (SELECT sno_personal.codper FROM sss_permisos_internos,sno_personal WHERE sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='ADMINISTRADOR' AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper ) ORDER BY sno_personal.codper 15/10/2019 16:49:14 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Invalid query: ERROR: no existe la columna sno_personal.diasservprevper LINE 1: ... sno_personal.anoservprefijo, sno_personal.codorg,sno_person... ^ Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper, sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa, sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin, sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper, sno_personal.talpanper, sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,sno_personal.diasservprevper, sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, sno_personal.habediusu, sno_personal.feccieedi, (SELECT denger FROM srh_gerencia WHERE srh_gerencia.codemp = sno_personal.codemp AND srh_gerencia.codger = sno_personal.codger ) AS denger, (SELECT desorg FROM srh_organigrama WHERE srh_organigrama.codemp = sno_personal.codemp AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, (SELECT denunivipladin FROM srh_unidadvipladin WHERE srh_unidadvipladin.codemp = sno_personal.codemp AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, (SELECT dentippersss FROM sno_tipopersonalsss WHERE sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss, (SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, (SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, (SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, (SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia WHERE sno_personal.codemp='0001' AND sno_profesion.codemp = sno_personal.codemp AND sno_profesion.codpro = sno_personal.codpro AND sigesp_pais.codpai = sno_personal.codpai AND sigesp_estados.codpai = sno_personal.codpai AND sigesp_estados.codest = sno_personal.codest AND sigesp_municipio.codpai = sno_personal.codpai AND sigesp_municipio.codest = sno_personal.codest AND sigesp_municipio.codmun = sno_personal.codmun AND sigesp_parroquia.codpai = sno_personal.codpai AND sigesp_parroquia.codest = sno_personal.codest AND sigesp_parroquia.codmun = sno_personal.codmun AND sigesp_parroquia.codpar = sno_personal.codpar AND sno_personal.codper ILIKE '%%' AND sno_personal.cedper ILIKE '%%' AND sno_personal.nomper ILIKE '%%' AND sno_personal.apeper ILIKE '%%' AND sno_personal.numexpper ILIKE '%%' AND sno_personal.codper IN (SELECT sno_personal.codper FROM sss_permisos_internos,sno_personal WHERE sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='ADMINISTRADOR' AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper ) ORDER BY sno_personal.codper 15/10/2019 16:49:23 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Invalid query: ERROR: no existe la columna sno_personal.diasservprevper LINE 1: ... sno_personal.anoservprefijo, sno_personal.codorg,sno_person... ^ Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper, sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa, sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin, sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper, sno_personal.talpanper, sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,sno_personal.diasservprevper, sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, sno_personal.habediusu, sno_personal.feccieedi, (SELECT denger FROM srh_gerencia WHERE srh_gerencia.codemp = sno_personal.codemp AND srh_gerencia.codger = sno_personal.codger ) AS denger, (SELECT desorg FROM srh_organigrama WHERE srh_organigrama.codemp = sno_personal.codemp AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, (SELECT denunivipladin FROM srh_unidadvipladin WHERE srh_unidadvipladin.codemp = sno_personal.codemp AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, (SELECT dentippersss FROM sno_tipopersonalsss WHERE sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss, (SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, (SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, (SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, (SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia WHERE sno_personal.codemp='0001' AND sno_profesion.codemp = sno_personal.codemp AND sno_profesion.codpro = sno_personal.codpro AND sigesp_pais.codpai = sno_personal.codpai AND sigesp_estados.codpai = sno_personal.codpai AND sigesp_estados.codest = sno_personal.codest AND sigesp_municipio.codpai = sno_personal.codpai AND sigesp_municipio.codest = sno_personal.codest AND sigesp_municipio.codmun = sno_personal.codmun AND sigesp_parroquia.codpai = sno_personal.codpai AND sigesp_parroquia.codest = sno_personal.codest AND sigesp_parroquia.codmun = sno_personal.codmun AND sigesp_parroquia.codpar = sno_personal.codpar AND sno_personal.codper ILIKE '%%' AND sno_personal.cedper ILIKE '%%' AND sno_personal.nomper ILIKE '%%' AND sno_personal.apeper ILIKE '%%' AND sno_personal.numexpper ILIKE '%%' AND sno_personal.codper IN (SELECT sno_personal.codper FROM sss_permisos_internos,sno_personal WHERE sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='ADMINISTRADOR' AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper ) ORDER BY sno_personal.codper 15/10/2019 16:52:27 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Invalid query: ERROR: no existe la columna sno_personal.diasservprevper LINE 1: ... sno_personal.anoservprefijo, sno_personal.codorg,sno_person... ^ Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper, sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa, sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin, sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper, sno_personal.talpanper, sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,sno_personal.diasservprevper, sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, sno_personal.habediusu, sno_personal.feccieedi, (SELECT denger FROM srh_gerencia WHERE srh_gerencia.codemp = sno_personal.codemp AND srh_gerencia.codger = sno_personal.codger ) AS denger, (SELECT desorg FROM srh_organigrama WHERE srh_organigrama.codemp = sno_personal.codemp AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, (SELECT denunivipladin FROM srh_unidadvipladin WHERE srh_unidadvipladin.codemp = sno_personal.codemp AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, (SELECT dentippersss FROM sno_tipopersonalsss WHERE sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss, (SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, (SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, (SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, (SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia WHERE sno_personal.codemp='0001' AND sno_profesion.codemp = sno_personal.codemp AND sno_profesion.codpro = sno_personal.codpro AND sigesp_pais.codpai = sno_personal.codpai AND sigesp_estados.codpai = sno_personal.codpai AND sigesp_estados.codest = sno_personal.codest AND sigesp_municipio.codpai = sno_personal.codpai AND sigesp_municipio.codest = sno_personal.codest AND sigesp_municipio.codmun = sno_personal.codmun AND sigesp_parroquia.codpai = sno_personal.codpai AND sigesp_parroquia.codest = sno_personal.codest AND sigesp_parroquia.codmun = sno_personal.codmun AND sigesp_parroquia.codpar = sno_personal.codpar AND sno_personal.codper ILIKE '%%' AND sno_personal.cedper ILIKE '%%' AND sno_personal.nomper ILIKE '%%' AND sno_personal.apeper ILIKE '%%' AND sno_personal.numexpper ILIKE '%%' AND sno_personal.codper IN (SELECT sno_personal.codper FROM sss_permisos_internos,sno_personal WHERE sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='ADMINISTRADOR' AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper ) ORDER BY sno_personal.codper