Issue with Custom security profile

Hi All,

I am using custom security profile with Restrict the people visible to each user using this profile option, and facing issue with fnd_global.employee_id.

The requirement is when an HR admin person logs into the admin responsibility, he/she  should be able to view the list of employees under the organizations to which they are associated.

Example: Consider there are 10 organizations A,B,C,D .... etc and HR Admin employee(Say X) is associated with organization A & B and another HR Admin(Y) is associated with organization C&D. Org level EIT is enabled and am associating an Admin person at each organization. I have created a custom profile with