SELECT

  A.shareSetID,
  A.createdBy,
  A.createdDateTime,
  A.status,
  A.errorMessageID,
  A.callbackID,
  A.shareType


INTO
  :shareSetID,
  :createdBy,
  :createdDateTime,
  :status,  
  :errorMessageID,
  :callbackID,
  :shareType


FROM

  AESShareSet A inner join AESSHAREITEM B ON A.SHARESETID = B.SHARESETID 

WHERE

  B.SOURCECASEID = :sourceCaseID;