05/03/2020 12:40:51 ***** ERROR DE SISTEMA: ***** egamez ***** 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, 000003030020002, 00002, ----------, 0200000856) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: DELETE FROM cxp_rd WHERE codemp='0001' AND numrecdoc='000003030020002' AND codtipdoc='00002' AND cod_pro='0200000856' AND ced_bene='----------' 05/03/2020 12:40:51 ***** ERROR DE SISTEMA: ***** egamez ***** 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, 000003030020002, 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='2020-0002-002-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='2020-0002-002-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 05/03/2020 12:40:51 ***** ERROR DE SISTEMA: ***** egamez ***** 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, 000003030020002, 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='2020-0002-003-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='2020-0002-003-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 05/03/2020 12:42:14 ***** ERROR DE SISTEMA: ***** egamez ***** 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, 000003030010004, 00002, ----------, 0200000856) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: DELETE FROM cxp_rd WHERE codemp='0001' AND numrecdoc='000003030010004' AND codtipdoc='00002' AND cod_pro='0200000856' AND ced_bene='----------' 05/03/2020 12:42:14 ***** ERROR DE SISTEMA: ***** egamez ***** 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, 000003030010004, 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='2020-0004-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='2020-0004-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 05/03/2020 13:10:53 ***** ERROR DE SISTEMA: ***** mcañate ***** ERROR-> Fecha Invalida. 05/03/2020 13:10:53 ***** ERROR DE SISTEMA: ***** mcañate ***** ERROR-> Datos Invalidos 05/03/2020 13:11:06 ***** ERROR DE SISTEMA: ***** mcañate ***** ERROR-> Fecha Invalida. 05/03/2020 13:11:06 ***** ERROR DE SISTEMA: ***** mcañate ***** ERROR-> Datos Invalidos 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 00002, ----------, 0200000856) todavía es referida desde la tabla «cxp_dt_solicitudes». Whole query: DELETE FROM cxp_rd WHERE codemp='0001' AND numrecdoc='000003030020002' AND codtipdoc='00002' AND cod_pro='0200000856' AND ced_bene='----------' 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0002-002-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='2020-0002-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0002-003-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='2020-0002-003-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0003-001-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='2020-0003-001-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0003-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='2020-0003-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0003-002-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='2020-0003-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0003-002-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='2020-0003-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0003-003-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='2020-0003-003-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0003-003-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='2020-0003-003-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0003-004-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='2020-0003-004-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0004-001-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='2020-0004-001-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0004-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='2020-0004-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0004-002-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='2020-0004-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0004-002-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='2020-0004-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0004-003-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='2020-0004-003-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0005-001-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='2020-0005-001-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0005-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='2020-0005-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0005-002-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='2020-0005-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0005-002-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='2020-0005-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0005-003-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='2020-0005-003-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0005-003-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='2020-0005-003-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0005-004-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='2020-0005-004-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0006-001-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='2020-0006-001-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0006-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='2020-0006-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0006-002-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='2020-0006-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0006-002-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='2020-0006-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0006-003-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='2020-0006-003-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0006-004-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='2020-0006-004-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0007-002-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='2020-0007-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0007-003-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='2020-0007-003-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0008-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='2020-0008-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0008-002-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='2020-0008-002-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 05/03/2020 14:23:36 ***** ERROR DE SISTEMA: ***** hfernandez ***** 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, 000003030020002, 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='2020-0009-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='2020-0009-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 05/03/2020 15:00:30 ***** ERROR DE SISTEMA: ***** bmoro ***** No se encontraron resultados 05/03/2020 15:00:49 ***** ERROR DE SISTEMA: ***** bmoro ***** No se encontraron resultados 05/03/2020 15:00:50 ***** ERROR DE SISTEMA: ***** bmoro ***** No se encontraron resultados 05/03/2020 15:01:30 ***** ERROR DE SISTEMA: ***** bmoro ***** No se encontraron resultados