Query for Current Elements Attached to an Employee Assignment
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.
Tagged:
1