postgresql7.1
select email as good_email from parties
where party_id = (select apv.attr_value
from apm_parameter_values apv,
apm_parameters ap
where ap.package_key = :package_key
and ap.parameter_name = 'NotificationSender'
and ap.parameter_id = apv.parameter_id)::integer