Operation Details
Description: Returns the details of a contact phone number for a hearing participant
Sterotype: ns
SQL 
SELECT
  p.phoneNumber,
  p.phoneCountryCode,
  p.phoneAreaCode,
  p.phoneExtension,
  h.recordStatus,
  c.startDate,
  c.endDate,
  cr.concernRoleName,
  p.comments,
  h.caseParticipantRoleID,
  h.hearingPhoneContactID
INTO
  :phoneNumber,
  :phoneCountryCode,
  :phoneAreaCode,
  :phoneExtension,
  :recordStatus,
  :phoneStartDate,
  :phoneEndDate,
  :concernRoleName,
  :comments,
  :caseParticipantRoleID,
  :hearingPhoneContactID 
FROM
  HearingPhoneContact h,
  ConcernRolePhoneNumber c,
  PhoneNumber p,
  ConcernRole cr 
WHERE hearingPhoneContactID = :hearingPhoneContactID 
  AND h.concernRolePhoneNumberID = c.concernRolePhoneNumberID 
  AND c.phoneNumberID = p.phoneNumberID 
  AND cr.concernRoleID = c.concernRoleID