As Louis states, there's no mapping from the service to the rule that would allow this, unfortunately. What you'll have is a series of rules for events, each with a series of actions that are fired when the condition on that rule is met. Whether any given service matches that condition will not be something you could easily check from a SQL query.
Some rules may be fairly obvious to spot, e.g. checking the service option by name, or using class/subclass to identify a type of service option. Others may or may not be relevant for a given request, depending on (for example) who the requested_for user is, which Business Unit raises the request, or which options in a service are chosen.
If you suspect, but need to confirm, if a particular rule is firing on a test request, you may wish to add a "debugging" action that e.g. emails you with an appropriate notification when the rule fires, in addition to the ones you already have defined.
Regards
Iain