SELECT
  allegationID,
  ActionChildLink.actionChildLinkID,
  type,
  allegationDateTime,
  location,
  Allegation.recordStatus,
  ActionChildLink.versionNo
INTO
  :allegationID,
  :actionChildLinkID,
  :type,
  :allegationDateTime,
  :location,
  :recordStatus,
  :versionNo 
FROM
  Allegation,
  ActionChildLink 
WHERE ActionChildLink.actionID = :actionID 
  AND ActionChildLink.childType = :childType 
  AND ActionChildLink.childLinkID = Allegation.allegationID 
  AND ActionChildLink.recordStatus = :recordStatus