Operation Details
Description: Returns a list of admin integrated cases associated with the service plan referenced by the key
Sterotype: nsmulti
SQL 
SELECT
  adminIntegratedCaseID,
  integratedCaseType,
  homePageName,
  memberHomePageName
INTO
  :caseID,
  :integratedCaseType,
  :homePageName,
  :memberHomePageName 
FROM
  AdminIntegratedCase 
WHERE statusCode = :recordStatus 
  AND adminIntegratedCaseID NOT IN 
  ( 
  SELECT
    adminIntegratedCaseID 
  FROM
    AdminICServicePlanLink 
  WHERE servicePlanID = :servicePlanID 
  )