{"id":15935,"date":"2023-10-19T12:18:26","date_gmt":"2023-10-19T18:18:26","guid":{"rendered":"https:\/\/sada.services\/?p=15935"},"modified":"2023-10-19T16:06:53","modified_gmt":"2023-10-19T22:06:53","slug":"sigesa-sql-obtener-el-plan-operativo-funcional-de-apeuna","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=15935","title":{"rendered":"SIGESA: SQL Obtener el Plan Operativo funcional de APEUNA"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>SELECT \n* \nFROM PLAN_OPERATIVO PO\nWHERE\nPO.UNIDAD_EJECUTORA = 99\nand PO.PERIODO_ANUAL = 202 \nAND ESTADO_FORMULACION_OPE IN (\n                    SELECT VALOR FROM PARAMETRO \n                    WHERE LLAVE = 'param_ppi_ppo_estadoFormulacionOpe_aprobado_unidad_integradora' OR LLAVE = 'param_ppi_ppo_estadoFormulacionOpe_aprobado_unSoloNivel')\nAND PO.ETAPA_PLAN = (\n      SELECT MAX(ETAPA_PLAN) \n                FROM PLAN_OPERATIVO \n                WHERE \n                UNIDAD_EJECUTORA = 99 \n                AND PERIODO_ANUAL = 202 \n                AND ESTADO_FORMULACION_OPE IN (\n                    SELECT VALOR FROM PARAMETRO \n                    WHERE LLAVE = 'param_ppi_ppo_estadoFormulacionOpe_aprobado_unidad_integradora' OR LLAVE = 'param_ppi_ppo_estadoFormulacionOpe_aprobado_unSoloNivel'\n                    )          \n);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[443],"tags":[587,479],"class_list":["post-15935","post","type-post","status-publish","format-standard","hentry","category-sigesa","tag-activo","tag-sql"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/15935","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15935"}],"version-history":[{"count":3,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/15935\/revisions"}],"predecessor-version":[{"id":15938,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/15935\/revisions\/15938"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15935"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15935"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}