FUNCTION cf_owner_nameformula
   RETURN CHAR
IS
   v_owner_name    VARCHAR2 (60);
   v_property_no   property.property_no%TYPE;
BEGIN
   SELECT p.property_no, get_name_fn (:tp_mail)
     INTO v_property_no, v_owner_name
     FROM prop_owner po, prop_ownership pos, property p
    WHERE po.tax_payer_no = :tax_payer_no
      AND pos.tax_payer_no = po.tax_payer_no
      AND p.property_no = pos.property_no
      AND (   SYSDATE BETWEEN pos.start_date AND pos.end_date
           OR (SYSDATE >= pos.start_date AND pos.end_date IS NULL)
          )
      AND fl_void = 'N';

   determine_address (:tp_mail,
                      v_property_no,
                      :tax_type_no,
                      TO_NUMBER (''),
                      :p_tax_payer_name,
                      :p_rep_name,
                      :p_mailing_address,
                      :p_city_name,
                      :p_post_code_desc,
                      :p_country_name,
                      :p_parish_name
                     );
   RETURN (v_owner_name);
EXCEPTION
   WHEN NO_DATA_FOUND
   THEN
      RETURN (NULL);
END;