What's new in Customer Journeys?

Connect and learn more!
Sql query to get payroll process name Under a batch Name /Instance name — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Sql query to get payroll process name Under a batch Name /Instance name

Received Response
30
Views
2
Comments

Hi ,


I am looking for SQL table to get payroll process name currently i can get batchname/Instance name via below query :


SELECT pfi.instance_name FROM pay_flows pf,pay_flow_instances pfiWHERE 1=1AND pf.base_flow_id = pfi.base_flow_idAND pfi.LAST_UPDATE_DATE < sysdate AND pf.base_flow_name = -- - give the name of your HCM extract

Please help me get underlying process name too , I need the process name inside yellow circle


Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!