select hl.
meaning
,ppa.payroll_action_id
,pra.payroll_rel_action_id
,pra.action_status
,ppa.effective_date
from fusion.pay_payroll_rel_Actions pra
,fusion.pay_payroll_actions ppa
,fusion.hr_lookups hl
,fusion.pay_pay_relationships_dn pre
where ppa.payroll_action_id = pra.payroll_action_id
and ppa.action_type = hl.lookup_code
and hl.lookup_type = 'ACTION_TYPE'
and pre.payroll_relationship_id = pra.payroll_relationship_id
and pre.payroll_relationship_number ='000138295'
order by ppa.payroll_action_id desc;
300000040119074
select [Link]
,ppa.payroll_action_id
,pra.payroll_rel_action_id
,pra.action_status
,ppa.effective_date
from fusion.pay_payroll_rel_Actions pra
,fusion.pay_payroll_actions ppa
,fusion.hr_lookups hl
,fusion.pay_pay_relationships_dn pre
,fusion.PAY_DIR_CARDS_F pdc
where ppa.payroll_action_id = pra.payroll_action_id
and pdc.dir_card_id='300000027297214'
and ppa.action_type = hl.lookup_code
and hl.lookup_type = 'ACTION_TYPE'
and pre.payroll_relationship_id = pra.payroll_relationship_id
and pre.payroll_relationship_id = pdc.payroll_relationship_id
--and pre.payroll_relationship_number ='000138295'
order by ppa.payroll_action_id desc;
select * from PAY_DIR_CARDS_F where dir_card_id ='300000027297214'
select ppa.effective_date,
pra.action_status, pfi.instance_name,
pfi.created_by,pfi.creation_date
from pay_payroll_rel_actions pra,
pay_payroll_actions ppa,
pay_pay_relationships_dn prl,
pay_requests prq,
pay_flow_instances pfi
where ppa.payroll_action_id=pra.payroll_action_id
and pra.PAYROLL_RELATIONSHIP_ID=prl.PAYROLL_RELATIONSHIP_ID
and prl.payroll_relationship_number like '000138295'
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.action_type,ppa.effective_date;
Select * from PAY_PAY_RELATIONSHIPS_DN
where payroll_relationship_id ='300000017031724'
Payroll relationship number = '000138295';
