HR Security Profile

Hi,

I created a HR Custom Security Profile to restrict the records based on the Scorecard values.

Custom Security:

person.person_id in (select person_id from per_all_assignments_f where ass_attribute11 = 'APA' and trunc(sysdate) between effective_start_date and effective_end_date)

For Ex:

On 31-DEC-2016 employee A belongs to XXX scorecard. In forms if i search for employee A with past date (31-DEC-2016) the employee is appearing, even though the employee does not belong to APA on 31-DEC-2016.

My requirement is to restrict the employees who does not belongs to APA even thought it has been date tracked.