Payment Elements And Element Sets Information

SELECT pes.element_set_name, petf.element_name, petf.description

  FROM pay_element_sets_tl pes,

       pay_element_type_rules petr,

       pay_element_types_f petf,

       per_all_assignments_f paaf,

       pay_element_entries_f peef,

       per_all_people_f papf

 WHERE pes.element_set_id = petr.element_set_id

   AND petf.element_type_id = petr.element_type_id

   AND TRUNC (SYSDATE) BETWEEN petf.effective_start_date

                           AND petf.effective_end_date

   AND papf.person_id = paaf.person_id

   AND paaf.assignment_id = peef.assignment_id

---AND PAPF.EMPLOYEE_NUMBER = '30987';