select nr.user_id as request_user_id, nr.request_id, (select name from notification_intervals where interval_id= nr.interval_id) as interval_name ,(select short_name from notification_delivery_methods where delivery_method_id=nr.delivery_method_id) as delivery_name from notification_requests nr where nr.object_id = :object_id and nr.type_id = :type_id select party_approved_member_map.member_id as user_id from party_approved_member_map, group_member_map where group_member_map.member_id = party_approved_member_map.member_id and party_id = :party_id select object_type from acs_objects where object_id = :object_id select pretty_name from notification_types where type_id = :type_id select member_id as user_id from group_member_map where group_id = :group_id select 1 from users where user_id = :party_id