Person Security Profile with custom criteria comes with a SQL error

Summary

SQL for custon criteria works in BI but not for the person security profile

Content

Dear all

 

I have created custom criteria for s person security profile::

&TABLE_ALIAS.person_id IN
(
SELECT asg.person_id
FROM per_all_assignments_m asg
, per_periods_of_service ps
, per_person_types_vl pt
WHERE asg.assignment_type IN ('E','C','N','P')
AND asg.person_type_id = pt.person_type_id
AND pt.active_flag = 'Y'
AND pt.user_person_type <> 'Executive' -- Replace the user person type name as per your requirement
AND asg.effective_latest_change = 'Y'