Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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):
Tagged:
0