Get Started with Redwood for Oracle Cloud HCM Begin Now
SQL Query for element pay values getting duplicated
Summary:
Dear All
I am trying develop a BIP Report which will fetch the values for elements processed on certain period of time , I prepare the Query for overtime , but when I run I am getting duplicate values , I mean I am getting two rows of same values and total amount is doubled ,Please refer the attached query , am I missing anything or any joints
SELECT prrv.RESULT_VALUE "OVERTIME" ,PAPF.PERSON_ID,ppa.effective_date,PPA.PAYROLL_ACTION_ID,pet.element_name
FROM pay_element_types_tl pet,
PAY_RUN_RESULTS prr,
PAY_RUN_RESULT_VALUES prrv,
PAY_PAYROLL_REL_ACTIONS ppra,
Tagged:
0