Fix approval_rules check for any_merge_request rule type

What does this MR do and why?

This MR updates the query to get the approval rules scoped to the MR rather than from the project. This does not cause any bug as we check if the approval rules exist for the MR before invoking the worker, but adding this check would add an extra safety.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Addresses #456055