Operation Details
Description: Returns the details needed for the hearing phone contact modify
Sterotype: ns
SQL 
SELECT
  c.concernRolePhoneNumberID,
  c.concernRoleID,
  c.phoneNumberID,
  c.typeCode,
  p.phoneNumber,
  p.phoneCountryCode,
  p.phoneAreaCode,
  p.phoneExtension,
  c.startDate,
  c.endDate,
  cr.concernRoleName,
  p.comments,
  h.caseParticipantRoleID,
  h.recordStatus,
  p.statusCode,
  cr.primaryPhoneNumberID,
  cr.versionNo
INTO
  :concernRolePhoneNumberID,
  :concernRoleID,
  :phoneNumberID,
  :typeCode,
  :phoneNumber,
  :phoneCountryCode,
  :phoneAreaCode,
  :phoneExtension,
  :phoneStartDate,
  :phoneEndDate,
  :concernRoleName,
  :comments,
  :caseParticipantRoleID,
  :phoneContactStatus,
  :phoneNumberStatus,
  :primaryPhoneNumberID,
  :concernRolePhoneVersionNo 
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