Facing issue in HCM extract with PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE

Summary

Facing issue in HCM extract with PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE

Content

Hi Experts,

I'm facing a very different issue in HCM extract. 

1. I have a extract with two UE's PER_EXT_SEC_PERSON_NOW_FUTURE_UE(root UE) and PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE

2. I have added additional condition like below

    asg.assignment_type='E'
and
asg.ASSIGNMENT_STATUS_TYPE='ACTIVE'
and
asg.system_person_type='EMP'
and
not exists
(
select 1 from per_person_types_tl pptl
where
pptl.person_type_id=asg.person_type_id
and
pptl.language=userenv('LANG')
and
USER_PERSON_TYPE IN ('Volunteer','Volunteer - Fixed-Term')