SELECT
  pd.caseID
INTO
  :recordID 
FROM
  ProductDelivery PD 
WHERE pd.caseID in 
  ( 
  SELECT
    DISTINCT FC.caseID 
  FROM
    FinancialComponent FC 
  WHERE FC.statusCode = :statusCode 
    AND 
    (
      :searchByProcessingDateFrom = '0' 
      OR FC.nextProcessingDate >= :processingDateFrom 
    ) 
    AND FC.nextProcessingDate <= :processingDateTo 
    AND 
    (
      :searchByDeliveryMethod = '0' 
      OR FC.nomineeDelivMethod = :deliveryMethod 
    ) 
    AND 
    (
      :searchByProductID = '0' 
      OR FC.productID = :productID 
    ) 
  ) 
ORDER BY pd.productID