14/09/2016 09:12:29 ***** ERROR DE SISTEMA: ***** gleon ***** No se encontraron resultados 14/09/2016 09:12:40 ***** ERROR DE SISTEMA: ***** gleon ***** No se encontraron resultados 14/09/2016 09:13:00 ***** ERROR DE SISTEMA: ***** gleon ***** No se encontraron resultados 14/09/2016 09:13:14 ***** ERROR DE SISTEMA: ***** gleon ***** No se encontraron resultados 14/09/2016 09:13:41 ***** ERROR DE SISTEMA: ***** gleon ***** No se encontraron resultados 14/09/2016 09:13:54 ***** ERROR DE SISTEMA: ***** gleon ***** No se encontraron resultados 14/09/2016 09:14:28 ***** ERROR DE SISTEMA: ***** gleon ***** No se encontraron resultados 14/09/2016 09:14:59 ***** ERROR DE SISTEMA: ***** gleon ***** No se encontraron resultados 14/09/2016 11:23:54 ***** ERROR DE SISTEMA: ***** eguevara ***** ERROR-> 14/09/2016 18:49:40 ***** ERROR DE SISTEMA: ***** mcaldera ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1406, 0000000127, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1406' 14/09/2016 18:49:55 ***** ERROR DE SISTEMA: ***** mcaldera ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1406, 0000000127, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1406' 14/09/2016 18:51:22 ***** ERROR DE SISTEMA: ***** mcaldera ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1406, 0000000127, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1406' 14/09/2016 19:24:03 ***** ERROR DE SISTEMA: ***** mcaldera ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1406, 0000000127, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1406' 14/09/2016 19:31:20 ***** ERROR DE SISTEMA: ***** mcaldera ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1406, 0000000127, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1406' 14/09/2016 19:33:27 ***** ERROR DE SISTEMA: ***** mcaldera ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1406, 0000000127, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1406' 14/09/2016 19:34:21 ***** ERROR DE SISTEMA: ***** mcaldera ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1406, 0000000008, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1406' 14/09/2016 19:40:12 ***** ERROR DE SISTEMA: ***** mcaldera ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1406, 0000000008, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1406' 14/09/2016 19:40:40 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1403, 0000101112, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1403' 14/09/2016 19:41:24 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1406, 0000000122, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1406' 14/09/2016 19:43:58 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1403, 0000101113, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1403' 14/09/2016 19:45:18 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1403, 0000001012, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1403' 14/09/2016 19:45:59 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1403, 0000001247, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1403' 14/09/2016 19:46:47 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1403, 0000010113, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1403' 14/09/2016 19:47:45 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1403, 0000001015, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1403' 14/09/2016 19:48:34 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1403, 0000001014, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1403' 14/09/2016 19:49:15 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1403, 0000001013, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1403' 14/09/2016 19:49:56 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1403, 0000001017, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1403' 14/09/2016 19:50:33 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1403, 0000001011, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1403' 14/09/2016 20:38:40 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000000136, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:40:14 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000000136, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:41:17 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000006668, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:42:12 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0055456667, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:43:51 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000000125, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:44:53 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0055456669, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:45:50 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000000008, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:46:48 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000000009, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:47:50 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000006669, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:48:48 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000101112, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:49:56 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000101112, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:50:58 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000000017, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402' 14/09/2016 20:51:52 ***** ERROR DE SISTEMA: ***** yvergara ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1402, 0000101113, 2016, 017) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2016' AS anocur,'017' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1402'