Need Sql or BI Report to get Element Entry loaded for each Assignment Number ?

Summary:

I am loading Element Entries in Fusion Cloud on different Assignments as part of Conversion, I need a SQL or BI Report which would pull the loaded data (atleast the Assignment Number and Element Entry data)

Content (required):

Hello Experts,

We tried to join person_id of PAY_ELEMENT_ENTRIES_F table with person_id of PER_ALL_ASSIGNMENTS_M table (PAY_ELEMENT_ENTRIES_F.PERSON_ID = PER_ALL_ASSIGNMENTS_M .PERSON_ID), but since person id is same for all the assignments it is cross joining with all the assignment and we are getting cartesian product as output.