Human Capital Management - EBS (MOSC)

MOSC Banner

How to find on which eligibility criteria is element linking done?

edited Jul 31, 2013 6:51AM in Human Capital Management - EBS (MOSC) 10 commentsAnswered
In the eligibility criteria, the element can be linked to an organization, Job, Grade, People Group, Location, Position, Payroll, Employment Category and Salary.How to find on which eligibility criteria is element linking done?(For example if its linked to Job,grade,etc)?Is there a function or any method to retrieve this information.Following is the query I use,  but it returns multiple rows as we have OR condition.
select decode(pel.costable_type,'N','Not Costed','D','Distributed','C','Costed',pel.costable_type) type
                                         from pay_element_links_f pel
                                        WHERE
                                           ((select pg2.people_group_id from pay_people_groups pg2
Tagged:

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