Elements Entries Attached To A Person

SELECT DISTINCT papf.full_name employee_name, petf.element_name,

                petf.description element_description,

                peef.effective_start_date, peef.effective_end_date

           FROM per_all_people_f papf,

                per_all_assignments_f paaf,

                pay_element_entries_f peef,

                pay_element_types_f petf

          WHERE papf.person_id = paaf.person_id

            AND paaf.assignment_id = peef.assignment_id

            AND petf.element_type_id = peef.element_type_id

            AND TRUNC (SYSDATE) BETWEEN peef.effective_start_date

                                    AND peef.effective_end_date

            AND peef.effective_start_date BETWEEN paaf.effective_start_date

                                              AND paaf.effective_end_date

            AND peef.effective_start_date BETWEEN petf.effective_start_date

                                              AND petf.effective_end_date

            AND peef.effective_start_date BETWEEN papf.effective_start_date

                                              AND papf.effective_end_date

       ORDER BY papf.full_name;