Issue custom criteria in the person security profile

Content

Hello Everyone,

 

I have created the following SQL query to be entered into custom criteria (person security profile).

 

&TABLE_ALIAS.PERSON_ID IN (select distinct paam.person_id

 

from per_all_assignments_m paam

JOIN PER_ASG_RESPONSIBILITIES ast on ast.person_id=300000004331847

 

JOIN per_departments dep on dep.organization_id=paam.organization_id

 

JOIN per_dept_tree_node_v alb on dep.organization_id=alb.organization_id

start with dep.organization_id = ast.top_department_id
connect by prior dep.organization_id=alb.PARENT_ORGANIZATION_ID
)

 

Unfortunately, it is not working. Do you know if the problem is the JOIN function? The system alerts that using JOIN the performances will be affected.