Help in Query to get Variable Rate for a Benefit of an Employee

Summary:

Hello, Customer Connect!

I am in need of developing to get these scenario:

If the employee John is enrolled in the Benefit A with the option B, it have a rate value(rate that I can acess with the BEN_PRTT_RT_VAL table using prtt_enrt_rslt_id.). But I need to get the Option C in these benefit to get the rate "registered" for the person like the picture below

Currently I have the query in the .zip file

I need to get the option with the arrow to make some calculation.

Can anyone help me?

Content (please ensure you mask any confidential information):