--- Paises  ------------------
SELECT IDDIVPOLIT, CODDIVPOLIT, INITCAP(DIVPOLIT) DIVPOLIT
FROM   UTP.TB_GEN_DIVPOLITICA A
WHERE  IDTIPODIVPOLIT = 39 -- Tipo Pais
AND    IDDIVPOLIT IN (SELECT CODDIVPOLIT FROM UTP.TB_GEN_DIVPOLITICA
                      WHERE CODDIVPOLIT = A.IDDIVPOLIT)
ORDER BY DIVPOLIT

-- Departamentos -------------

SELECT IDDIVPOLIT, CODDIVPOLIT, INITCAP(DIVPOLIT) DIVPOLIT
FROM   UTP.TB_GEN_DIVPOLITICA A
WHERE  IDTIPODIVPOLIT = 40 -- Tipo Dpto
AND    CODDIVPOLIT    = 51 --IdDivPolit Pais
ORDER BY DIVPOLIT

-- Municipios ----------------

SELECT IDDIVPOLIT, CODDIVPOLIT, INITCAP(DIVPOLIT) DIVPOLIT
FROM   UTP.TB_GEN_DIVPOLITICA A
WHERE  IDTIPODIVPOLIT = 41 -- Tipo Mpio
AND    CODDIVPOLIT    = 308 --IdDivPolit Departamento
ORDER BY DIVPOLIT