SQL Queries - CAST Management Base - How to get Assessment model details from database

with AIPUpgrades as
(
select sph.REVISION_DATE,
       sph.REVISION
  from SYS_PACKAGE_HISTORY sph
where sph.PACKAGE_NAME = 'PMC_MAIN'
)
select distinct th.LOG_DATE,
       tt.TASK_LABEL,
       (select au.REVISION
          from AIPUpgrades au
         where au.REVISION_DATE = (select max(au0.REVISION_DATE)
                                     from AIPUpgrades au0
                                    where au0.REVISION_DATE < th.LOG_DATE)
       ) as UPGRADE_VERSION
  from TASKLOG_HISTORY th
  join TASKLOG_TASKS tt
    on tt.TASK_ID = th.TASK_ID
   and tt.TASK_LABEL like 'Merge Assessment Model%'
where th.LOG_CONTEXT = 'No Task message'
order by th.LOG_DATE;