sql to fetch payroll process having ui_task_status = 'COR_FLOWS'

Summary:

Need to pull standard flow status - which are 'rolledback' for US weekly payroll.

Parameter having p_start_date , p_end_date, p_payroll_name based on this parameter will identify period name and start_date and end_date from pay_period table. Currently below sql not giving correct data for Rolledback process count.

table - pay_flow_instances
column - ui_task_status
pay_flow_task_instances
pay_flow_tasks_vl
column - flow_task_name

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):