Query to get the Employee wise Elements and the effective date of the Element Entry in Oracle APPS

SELECT papf.employee_number,

       papf.full_name,

       petf.element_name,

       peef.effective_start_date

  FROM per_all_people_f papf,

       per_all_assignments_f paaf,

       pay_element_entries_f peef,

       pay_element_types_f petf,

       per_business_groups pb

 WHERE papf.person_id = paaf.person_id

   AND papf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

   AND papf.business_group_id = pb.business_group_id

   AND papf.current_employee_flag = 'Y'

   AND paaf.assignment_id = peef.assignment_id

   AND peef.element_type_id = petf.element_type_id

   AND TRUNC(SYSDATE) BETWEEN papf.effective_start_date

   AND papf.effective_end_date

   AND TRUNC(SYSDATE) BETWEEN paaf.effective_start_date

   AND paaf.effective_end_date

   AND TRUNC(SYSDATE) BETWEEN peef.effective_start_date

   AND peef.effective_end_date

   AND TRUNC(SYSDATE) BETWEEN petf.effective_start_date

   AND petf.effective_end_date

   AND petf.element_name IN ('XX_ELEMENT_NAME1', 'XX_ELEMENT_NAME2', 'XX_ELEMENT_NAME3')