Need inputs to generate check number sequentially

Content

Hi All,

We have a requirement to generate check number sequentially for all employees. We built below SQL query and attached to the Start Check Number and parameter basis as Post SQL Bind. We ran the "Generate Check Payment" process. Process completed successfully but we didn't get the output.

Any inputs to get the check number sequentially for all employees or Is there any setup to generate auto generation of check?

SQL Query:

  select max(pra.serial_number)+1 
  from   pay_payroll_rel_actions pra,
  pay_payroll_actions ppa
  where 1=1
  and ppa.payroll_action_id = pra.payroll_action_id
    AND ppa.action_type    IN ('H')