Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Query to fetch Run Result Element Entries & Balances for particular time period
Summary:
We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving multiple entries. If anyone can help on this, it would be great.
SELECT papf.person_number,
To_char(ppa.effective_date, 'MM/DD/YYYY') AS Process_Date,
To_char(ppa.date_earned, 'MM/DD/YYYY') AS Pay_Run_Date,
pet.element_name AS Element_Name,
pivt.name AS Input_Value_Name,
pev.screen_entry_value AS Value,
ptp.period_name AS Period_Name,
pap.payroll_name AS Payroll_Name
FROM per_all_people_f papf,
Tagged:
0