Not sure this is a security issue. When you select the JOB record normally query will automatically place criteria to select the max(effdt) <= Current Date.

Have you modified that criteria?

Go to the Criteria Tab.
Click Edit button (along side the effective date field.
Change the 'Condition Type to 'effdt >'
In the Expression 2 Type Box make sure radio button 'Current Date' is selected
In the Effective Sequence Options Box you probably want 'First' (assuming you are looking for a 'HIR' action.

That should get you future dated HIR rows.

I think you need to take a look at your HRMS Security settings.

See if you have enabled the future effective dated rows for the Security Access Type.
Set Up HRMS -> Security -> Core Row Level Security -> Security Access Type -> Security Type Table

Also check the HRMS Security Install Settings where you configure the actions that trigger future effective dated security rows.
Set Up HRMS -> Security -> Core Row Level Security -> Security Installation Settings -> Security Install Settings

This is based on HRMS 8.9. Im not sure about other versions.

/Ashar