Select
      hec_cas_cases.HEC_CAS_CaseID,
      hec_cas_cases.Creation_Timestamp
    From
      hec_cas_cases Inner Join
      hec_cas_case_relevantperformedactions
        On hec_cas_cases.HEC_CAS_CaseID = hec_cas_case_relevantperformedactions.Case_RefID And
        hec_cas_case_relevantperformedactions.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
        hec_cas_case_relevantperformedactions.IsDeleted = 0 Inner Join
      hec_act_plannedactions
        On hec_cas_case_relevantperformedactions.PerformedAction_RefID = hec_act_plannedactions.IfPlannedFollowup_PreviousAction_RefID And
        hec_act_plannedactions.IsPerformed = 1 And
        hec_act_plannedactions.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
        hec_act_plannedactions.IsDeleted = 0 Left Join
      hec_cas_case_billcodes
        On hec_cas_cases.HEC_CAS_CaseID = hec_cas_case_billcodes.HEC_CAS_Case_RefID And hec_cas_case_billcodes.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1'
    Where
      hec_cas_cases.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
      hec_cas_cases.IsDeleted = 0 And
      hec_cas_case_billcodes.HEC_CAS_Case_BillCodeID Is Null