   b.effective_end_date,
   a.enterprise_id
 from
-  argusmart.rm_case_assess as a,
-  argusmart.case_version_table as b
-where
-  (a.case_id = b.case_id) and
-  (a.enterprise_id = b.enterprise_id) and
-  (a.deleted_flag = convert(0,bigdecimal)) and
-  (convert(a.effective_start_date,timestamp) <= b.effective_start_date) and
-  (convert(a.effective_end_date,timestamp) > b.effective_start_date)
-
---------------------
-
+  rm_case_assess as a,
+  case_version_table as b
+where
+  (a.case_id = b.case_id) and
+  (a.enterprise_id = b.enterprise_id) and
+  (a.deleted_flag = convert(0,bigdecimal)) and
+  (convert(a.effective_start_date,timestamp) <= b.effective_start_date) and
+  (convert(a.effective_end_date,timestamp) > b.effective_start_date)
+
+--------------------
+
+  :case_classifications
 select
   a.enterprise_id,
   a.enterprise_id,

  cp.enterprise_id
  cp.sort_id
from
  argusmart.rm_case_product as cp,
  argusmart.case_version_table as cvt
where
  (cp.case_id = cvt.case_id) and
  (cp.enterprise_id = cvt.enterprise_id) and


--------------------

  :case_narrative
select
  a.enterprise_id
  a.case_id
