SELECT
  allitems.pageIdentifier
INTO
  :pageIdentifier 
FROM
  
  ( 
  SELECT
    MAX(effectiveFrom) AS maxeffectivefrom 
  FROM
    EvidenceScreen 
  WHERE effectiveFrom IS NOT NULL 
    AND effectiveFrom <= :effectiveFrom 
    AND relatedID = :relatedID 
    AND relatedType = :relatedType 
    AND pageType = :pageType 
    AND evidenceNodeCode = :evidenceNodeCode 
    AND recordStatus = :recordStatus 
  ) maxitems,
  EvidenceScreen allitems 
WHERE maxeffectivefrom = allitems.effectiveFrom 
  AND allitems.relatedID = :relatedID 
  AND allitems.relatedType = :relatedType 
  AND allitems.pageType = :pageType 
  AND allitems.evidenceNodeCode = :evidenceNodeCode 
  AND allitems.recordStatus = :recordStatus