Need to display Payroll flow and sub process along with parameter details

Content

Hi All,

We have created custom flow. In that custom flow we have attached two extracts. We are able to complete the custom flow. Now we have to display those details through OTBI/SQL means custom flow name name, payroll flow name and two sub process details along with parameter details.

Ex Custom flow is having two extracts (Extract1, Extract2).

Submitted custom flow with payroll flow name as xyz_flow. Now we need to display xyz_flow, sub process names (Extract1, Extract2) along with parameter details.

Please share if anyone is having SQL query.

 

Thanks,

Visu