pay_element_entries attached to assignments that are not active

Summary:

Pay_element_entries attched to assignments that are not active

Content (required):

trying to understand why the pay_element_entries are attached to assignments that are not active but employee is paid correctly

this employee has multiple assignments in the system (2 of them active). When I run the sql below against the data, the assignment number associated with the current element entries is pointing to an inactive assignment_number

sample:

expecting code below to show the highlighted assignment numbers. instead it is showing E107115-3 which is an inactive assignment. have traced the issue to the pay_element_entries.element_entry_id join to pay_entry_usages table, etc.