How can i restrict "Applicant.Ex-Employee" in Find Person window?
Dear Team Members,
I have created a custom security profile to restrict employees by writing sql query.
This query does not bring Applicant.Ex-Employee in SQL Developer. But the same query through security profile deos not work.
Please find attached screen shots of Security Profile and Find Person Window.
What makes wrong? knidly advise..Thanks in Advance...
*****************************SQL Statement************************************
select distinct papf.employee_number
FROM per_all_people_f papf
,per_all_assignments_f paaf
,PER_ASSIGNMENT_STATUS_TYPES past
WHERE papf.person_id = paaf.person_id
AND past.assignment_status_type_id=paaf.assignment_status_type_id
and PAST.USER_STATUS= 'Online SMA - New Joiners'