select a.name, a.description, ae.available_p, ae.detail_url, ae.default_contact_user_id, u.email as default_contact_email, u.first_names || ' ' || u.last_name as default_contact_name from acs_activities a, events_activities ae, cc_users u where a.activity_id = :activity_id and a.activity_id = ae.activity_id and ae.default_contact_user_id = u.user_id(+) declare begin events_activity.del(:activity_id); end;