Query to get actions that were processed on an employee in Fusion

 

select ppa.effective_date,ppa.action_type,
pra.action_status, pfi.instance_name,
pfi.created_by,pfi.creation_date
from FUSION.pay_payroll_rel_actions pra,
FUSION.pay_payroll_actions ppa,
FUSION.pay_pay_relationships_dn prl,
FUSION.pay_requests prq,
FUSION.pay_flow_instances pfi
where ppa.payroll_action_id=pra.payroll_action_id
and ppa.action_type<>'G' --remove to retrieve any generic actions, such as Generate automatic element entries ones
and pra.PAYROLL_RELATIONSHIP_ID=prl.PAYROLL_RELATIONSHIP_ID
and prl.payroll_relationship_number like 'XXX'
and pra.SOURCE_ACTION_ID is null
and prq.pay_request_id = ppa.pay_request_id
and prq.flow_instance_id=pfi.flow_instance_id
order by ppa.effective_date desc;