Operation Details
Description: Method to return a list of Concern Roles which are either Persons or Prospect Persons which do not have a PDC
Sterotype: nsmulti
SQL 
SELECT 
  C.CONCERNROLEID
INTO
  :concernRoleID 
FROM 
  CONCERNROLE C 
LEFT JOIN 
  CASEHEADER CH ON 
  C.CONCERNROLEID = CH.CONCERNROLEID AND 
  CH.CASETYPECODE='CT2001' AND 
  CH.STATUSCODE ='CS4' 
WHERE 
  CH.CONCERNROLEID IS NULL AND 
  (C.CONCERNROLETYPE = 'RL1' OR C.CONCERNROLETYPE = 'RL7')