Operation Details
Description: Returns all the CaseNomineeProdDelPattern records for a case.
Sterotype: nsmulti
SQL 
SELECT
  CaseNomineeProdDelPattern.caseNomineeProdDelPatternID,
  CaseNomineeProdDelPattern.fromDate,
  CaseNomineeProdDelPattern.toDate,
  CaseNomineeProdDelPattern.productDeliveryPatternID,
  CaseNomineeProdDelPattern.caseNomineeID,
  CaseNomineeProdDelPattern.statusCode
INTO
  :caseNomineeProdDelPatternID,
  :fromDate,
  :toDate,
  :productDeliveryPatternID,
  :caseNomineeID,
  :statusCode 
FROM
  CaseNominee,
  CaseNomineeProdDelPattern,
  CaseParticipantRole 
WHERE CaseParticipantRole.caseID = :caseID 
  AND CaseNominee.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseNomineeProdDelPattern.caseNomineeID = CaseNominee.caseNomineeID 
  AND 
  (
    
    (
      CaseNomineeProdDelPattern.fromDate <= :toDate 
      AND 
      (
        CaseNomineeProdDelPattern.toDate >= :fromDate 
        OR CaseNomineeProdDelPattern.toDate IS NULL 
      ) 
    ) 
    OR 
    (
      :toDate IS NULL 
      AND 
      (
        CaseNomineeProdDelPattern.toDate >= :fromDate 
        OR CaseNomineeProdDelPattern.toDate IS NULL 
      ) 
    ) 
  ) 
ORDER BY toDate ASC