Sql query to get payroll process name Under a batch Name /Instance name
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
Tagged:
0