Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Wednesday, 11 May 2016

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;
Share this article :


Post a Comment