Query to fetch Run Result Element Entries & Balances for particular time period

Summary:

We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving multiple entries. If anyone can help on this, it would be great.

SELECT papf.person_number,

    To_char(ppa.effective_date, 'MM/DD/YYYY') AS Process_Date,

    To_char(ppa.date_earned, 'MM/DD/YYYY')  AS Pay_Run_Date,

    pet.element_name             AS Element_Name,

    pivt.name                 AS Input_Value_Name,

    pev.screen_entry_value          AS Value,

    ptp.period_name              AS Period_Name,

    pap.payroll_name             AS Payroll_Name

FROM  per_all_people_f papf,