Operation Details
Description: To retrieve details from the ProspectPerson entity, and the AlternateName entity using the primaryAlternateID from the ProspectPerson record.
Sterotype: ns
SQL 
SELECT
  ProspectPerson.primaryAlternateID,
  ProspectPerson.maritalStatusCode,
  ProspectPerson.dateOfBirth,
  ProspectPerson.gender,
  ProspectPerson.ethnicOriginCode,
  AlternateName.title,
  AlternateName.firstForename,
  AlternateName.otherForename,
  AlternateName.surname
INTO
  :primaryAlternateID,
  :maritalStatusCode,
  :dateOfBirth,
  :gender,
  :ethnicOriginCode,
  :title,
  :firstForename,
  :otherForename,
  :surname 
FROM
  ProspectPerson,
  AlternateName 
WHERE ProspectPerson.concernRoleID = :concernRoleID 
  AND AlternateName.alternateNameID = ProspectPerson.primaryAlternateNameID