Issue with Person Security profile

Summary:

We have a custom sql written to prevent access for person records for certain grade ladder through person security profile. The custom sql criteria works well in one environment but does not work in another environment. The grade ladder is set up available in both the environments. Also the user 061755 has the same set of AOR defined.

Content (required):

Screenshot where it is not working.

Screenshot where it is working.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

(EXISTS

(SELECT 1 FROM PER_ALL_ASSIGNMENTS_M ASG,PER_ASG_RESPONSIBILITIES RES WHERE ASG.ASSIGNMENT_TYPE IN('E','C','P','N')