Human Capital Management - EBS (MOSC)

MOSC Banner

How can i restrict "Applicant.Ex-Employee" in Find Person window?

edited Feb 24, 2015 10:01AM in Human Capital Management - EBS (MOSC) 3 commentsAnswered

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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center