How to find on which eligibility criteria is element linking done?
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
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:
0