Operation Details
Description: Method to return a list of all Prospect Person snapshot records for a concernRoleID.
Sterotype: nsmulti
SQL 
SELECT
  prospectPersonSnapshotID,
  concernRoleID,
  personBirthName,
  maritalStatusCode,
  nationalityCode,
  creationDateTime,
  dateOfBirth
INTO
  :prospectPersonSnapshotID,
  :concernRoleID,
  :personBirthName,
  :maritalStatusCode,
  :nationalityCode,
  :creationDateTime,
  :dateOfBirth 
FROM
  ProspectPersonSnapshot 
WHERE concernRoleID = :concernRoleID 
ORDER BY creationDateTime DESC