SQL Query to Fetch Inactive Employees in Fusion HCM
select
paam.*
from
per_all_assignments_m paam ,
per_all_people_f papf
where 1=1
and papf.person_id = paam.person_id
and paam.ASSIGNMENT_STATUS_TYPE <> 'INACTIVE'
and paam.effective_latest_change = 'Y'
and paam.primary_flag = 'Y'
and paam.assignment_type= 'E'
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
and exists ( select '1' from per_all_assignments_m paam1 where paam1 .assignment_id = paam.assignment_id
and trunc(sysdate) between paam1 .effective_start_date and paam1 .effective_end_date
and t1.ASSIGNMENT_STATUS_TYPE <> 'INACTIVE'
)
No comments:
Post a Comment