Custom Criteria in the person security profile is not working as expected.

Summary:

Hi Everyone

We have created a person security profile with custom criteria. It is giving expected result when previewing in the security profile but when Data role attached to the user and user logins, goes to person management, it is not giving the expected. I would like to know whether the written query is valid. When i validated the query at the person security profile page, it was valid.

&TABLE_ALIAS.PERSON_ID IN (select paam.PERSON_ID
from  per_all_assignments_m paam,
      hr_organization_information_f hoif
where 1=1
and   paam.effective_latest_change='Y'
and   paam.assignment_type = 'E'