SQL to get Accrual Plan Balance

Summary:

SQL to get Accrual Plan Balance

Content (please ensure you mask any confidential information):

Hi,

I am trying to get the Accrual Plan Balance just as shown in the screen. I am neither able to achieve it through OTBI analysis nor through SQL query.

I am only able to get -21 using below SQL:

select sum(value) from (
SELECT PAPF.PERSON_NUMBER,
APAED.PROCD_DATE,
APAED.VALUE
FROM PER_ALL_PEOPLE_F PAPF,
ANC_PER_PLAN_ENROLLMENT APPE,
ANC_PER_ACRL_ENTRY_DTLS APAED,
ANC_ABSENCE_PLANS_F_TL AAPFT
WHERE PAPF.PERSON_ID = APPE.PERSON_ID
AND APPE.PERSON_ID = APAED.PERSON_ID