30/01/2021 22:13:33 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->SNO MÉTODO->uf_reparar_conceptopersonal ERROR->Invalid query: ERROR: missing FROM-clause entry for table "pn" LINE 16: WHERE pn.codemp='0001' ^ Whole query: INSERT INTO sno_conceptopersonal (codemp, codnom, codper, codconc, aplcon, valcon, acuemp, acuiniemp, acupat, acuinipat) SELECT codemp, codnom, codper, codconc, glocon, 0, 0, 0, 0, 0 FROM ( SELECT pn.codemp, c.codnom, pn.codper, c.codconc, c.glocon, 0, 0, 0, 0, 0, cp.codper AS codper2 FROM sno_concepto c INNER JOIN sno_personalnomina pn ON pn.codemp=c.codemp AND pn.codnom=c.codnom LEFT JOIN sno_conceptopersonal cp ON cp.codemp=c.codemp AND cp.codnom=c.codnom AND cp.codconc=c.codconc AND cp.codper=pn.codper ) AS cp WHERE pn.codemp='0001' AND (codper2 IS NULL OR codper2 = '')