Get total amount paid for single element for the selected date range- SQL help

Summary

How to retive sum of total amount paid for the employee for one element

Content

Hello all,

I am new to HCM payroll and have requirement to get total amount paid for each element for the given time period for each employee. I am trying the following SQL and unable to get the results. Please help.

SELECT Distinct PET.ELEMENT_TYPE_ID,PET.base_ELEMENT_NAME, --PIV.NAME,
PEEV.EFFECTIVE_START_DATE ELE_ENTR_EFF_STDT, PEEV.EFFECTIVE_END_DATE
ELE_ENTR_EFF_ENDT,PEEV.SCREEN_ENTRY_VALUE,
PEE.ELEMENT_ENTRY_ID
--,PEL.PAYROLL_ID, Prf.Payroll_name,PEE.ASSIGNMENT_ID