asdfasdfas

SELECT CODE_DESIGNATOR AS VALORES FROM TIPOPROCEDIMIENTOS WHERE INDICE_TIPOPROCEDIMIENTO IN(
            SELECT INDICE_TIPOPROCEDIMIENTO FROM OBJETOS WHERE INDICE_OBJETO IN (
                SELECT MAX(INDICE_OBJETO) FROM OBJETOS OB
                JOIN SERIES SER ON SER.INDICE_SERIE = OB.INDICE_SERIE
                JOIN ESTUDIOS EST ON EST.INDICE_ESTUDIO = SER.INDICE_ESTUDIO
                WHERE EST.ACCESSION_NUMBER=''
            )
        )
        UNION
        --NO EXPIRÓ
        SELECT 'NO' FROM SESIONES_MEDICAP WHERE TOKEN_LEBOX = ''
        AND SYSDATE BETWEEN FECHA_ULTIMA_ACCION AND (FECHA_ULTIMA_ACCION + (1/(24*60))*30)
        ;