Human Capital Management - EBS (MOSC)

MOSC Banner

Query returns multiple rows where 1 row is expecte

edited Mar 9, 2010 1:34AM in Human Capital Management - EBS (MOSC) 2 comments
I am running the following query to fetch the details of person enrolled in a plan. It is returning 2 rows where I expect only 1 row. Please can you suggest how I should filter the extra row.

select * from ben_prtt_enrt_rslt_f 

where person_id = <person_id value>

and pl_id = <pl_id value>

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