select first_names, last_name, email
from persons, parties
where person_id = :user_id
and person_id = party_id
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = :package_id
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = :parameter_name
select v.package_id, p.parameter_name, v.attr_value
from apm_parameters p, apm_parameter_values v
where p.parameter_id = v.parameter_id