SELECT
  IssueTimeConstraint.numberOfDays
INTO
  :numberOfDays 
FROM
  
  ( 
  SELECT
    MAX(fromDate) AS maxFromDate 
  FROM
    
    ( 
    SELECT
      fromDate 
    FROM
      IssueDelivery,
      IssueTimeConstraint 
    WHERE fromDate IS NOT NULL 
      AND fromDate <= :constraintDate 
      AND IssueDelivery.caseID = :caseID 
      AND IssueTimeConstraint.issueConfigurationID = IssueDelivery.issueConfigurationID 
      AND IssueTimeConstraint.constraintType = :constraintType 
      AND IssueTimeConstraint.recordStatus = :recordStatus 
    ) temp 
  ) maxitems,
  IssueDelivery,
  IssueTimeConstraint 
WHERE 
  (
    
    (
      maxFromDate IS NOT NULL 
      AND maxFromDate = IssueTimeConstraint.fromDate 
    ) 
    OR 
    (
      maxFromDate IS NULL 
      AND IssueTimeConstraint.fromDate IS NULL 
    ) 
  ) 
  AND IssueDelivery.caseID = :caseID 
  AND IssueTimeConstraint.issueConfigurationID = IssueDelivery.issueConfigurationID 
  AND IssueTimeConstraint.constraintType = :constraintType 
  AND IssueTimeConstraint.recordStatus = :recordStatus