Operation Details
Description: Returns a count of case nominees who use the bank account and are to be paid by a specified delivery method in the life time of a case.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  CaseNomineeDestination,
  CaseNominee,
  CaseNomineeProdDelPattern,
  ProductDeliveryPatternInfo 
WHERE CaseNomineeDestination.destinationID = :destinationID 
  AND CaseNomineeDestination.destinationType = :destinationType 
  AND CaseNomineeDestination.statusCode = :statusCode 
  AND CaseNomineeProdDelPattern.caseNomineeID = CaseNomineeDestination.caseNomineeID 
  AND ProductDeliveryPatternInfo.productDeliveryPatternID = CaseNomineeProdDelPattern.productDeliveryPatternID 
  AND ProductDeliveryPatternInfo.deliveryMethodID = :deliveryMethodID 
  AND CaseNominee.caseNomineeID = CaseNomineeDestination.caseNomineeID 
  AND 
  (
    CaseNominee.defaultNomInd = :defaultNomInd 
    OR EXISTS 
    ( 
    SELECT
      * 
    FROM
      CaseNomineeObjective 
    WHERE CaseNomineeObjective.caseNomineeID = CaseNomineeDestination.caseNomineeID 
    ) 
  )