Human Capital Management - EBS (MOSC)

MOSC Banner

How to use a custom select in an eligibility profile for learner group?

edited Mar 5, 2018 9:57AM in Human Capital Management - EBS (MOSC) 5 commentsAnswered ✓

Hello,

I want to create an eligibility profile, that will be used for a Learning Management learner group.  To determine a person's eligibility, I want to put the following two selects into a function, add them up, and if the function returns a value > 0, include the person, otherwise exclude the person.

The selects determine if an employee actually supervises another, or is a timecard approver for another.

select count (1)
from per_assignments_f where supervisor_id = <person_id being evaluated>
and sysdate between effective_start_date and effective_end_date
and primary_flag = 'Y' and assignment_type = 'E'

select count (1)

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