oracle8.1.6 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)