SELECT
  typeCode,
  addressData,
  startDate,
  endDate,
  ContactAddress.statusCode,
  contactAddressID,
  Address.addressID,
  Address.versionNo,
  ContactAddress.versionNo
INTO
  :typeCode,
  :addressData,
  :startDate,
  :endDate,
  :statusCode,
  :contactAddressID,
  :addressID,
  :addressVersionNo,
  :contactAddressVersionNo 
FROM
  Address,
  ContactAddress 
WHERE ContactAddress.contactID = :contactID 
  AND Address.addressID = ContactAddress.addressID 
  AND ContactAddress.statusCode = :statusCode