Operation Details
Description: Count all appealed cases which have not had their receipt notice generated.
Sterotype: ns
SQL 
SELECT
  COUNT (appealRelationshipID)
INTO
  :recordCount 
FROM
  AppealRelationship 
WHERE appealCaseID = :appealCaseID 
  AND receiptNoticeIndicator = :receiptNoticeIndicator 
  AND recordStatus = :recordStatus