Employees,who have future DOJ are not visible when querying

Hello

I have defined security profile with restricted access to employees and defined custom security as

assignment.person_id in
(
Select Distinct (Papf.Person_Id)
  From Per_All_People_f Papf, Per_All_Assignments_f Paaf
 Where Papf.Person_Id = Paaf.Person_Id
     And (Paaf.Organization_Id In
       (Select Organization_Id
           From Hr_All_Organization_Units
          Where Name Like '%xyz%') Or Paaf.Organization_Id = 123))

But I am unable to query employee who have Date of joining as future date.

Please suggest if it is standard HRMS feature when you define security profile that you can not query untill date of joining is greater than sysdate.