Human Capital Management - EBS (MOSC)

MOSC Banner

Query for Current Elements Attached to an Employee Assignment

edited Sep 12, 2017 12:40PM in Human Capital Management - EBS (MOSC) 8 commentsAnswered ✓

Hi All, i'm trying to write a query to get the Current Elements Attached to an Employee Assignment, here's what i got so far:

select  ety.element_namefrom    per_assignments_x pax    ,   per_assignment_status_types pst    ,   PAY_ELEMENT_ENTRIES_X PEEF    ,   pay_element_types_X ety    where   pax.assignment_id = <<Assignment ID>>and     ety.element_type_id = PEEF.element_type_iDand     pax.assignment_status_type_id = pst.assignment_status_type_idand     PEEF.ASSIGNMENT_ID = pax.ASSIGNMENT_IDand     PEEF.effective_start_Date   <= sysdateand     PEEF.effective_end_Date     >= sysdateand     pst.user_status = 'Active Assignment'and     pax.assignment_type = 'E';

However, the employee I'm querying has 15 Elements attached, but the query data set returns 20 records.

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