Query to get Element Advance Salary in Oracle Apps

 SELECT prrv.result_value

      ,paa.assignment_id

  ,paaf.assignment_id

  ,papf.employee_number

 FROM pay_run_results prr1

     ,pay_element_types_f petf

,pay_run_result_values prrv

,pay_input_values_f piv

,pay_assignment_actions paa

,pay_payroll_actions ppa

,per_all_assignments_f paaf

,per_all_people_f papf

WHERE prr1.element_type_id = petf.element_type_id

  AND prr1.run_result_id = prrv.run_result_id

  AND prrv.input_value_id = piv.input_value_id

  AND prr1.assignment_action_id = paa.assignment_action_id

  AND paaf.assignment_id = paa.assignment_id

  and paaf.person_id = papf.person_id

  AND element_name = 'Advance Salary'

  AND piv.name = 'Pay Value'

  AND ppa.payroll_action_id = paa.payroll_action_id                         

  AND ppa.action_type IN ('Q', 'R')

  AND SYSDATE BETWEEN piv.effective_start_date AND  piv.effective_end_date

  AND SYSDATE BETWEEN petf.effective_start_date AND  petf.effective_end_date

  AND SYSDATE BETWEEN paaf.effective_start_date AND  paaf.effective_end_date

  AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date

  and prrv.result_value > '0'

  AND ppa.effective_date='31-DEC-2020'