SQL query needed to fetch "Calculate Payroll", "Make EFT Payments" process and employee details
We want to create a BIP report in Oracle Fusion cloud to get the "Payroll Flow" name for "Calculate Payroll" and "Make EFT Payments" i.e. to get the payroll flow names for both the processes along with the employee details and amount to be paid. But, we are not sure about the tables we need to look for and the joins we need to add to fetch those 3 tables details.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):