Projected Accrual hours are not appearing in ANC_PER_ACRL_ENTRY_DTLS table

Hi,

we have a requirement to get total Available Accrual Leave Balance hours for each employee. hence, I am using ANC_PER_ACRL_ENTRY_DTLS table to sum up all the values for each accrual. While testing, we found that Projected Accrual hours are not appearing in the table but able to see from front end.

are there any other tables to get employees Projected Accrual hours? could anyone please assist us to get total Available Accrual Leave Balance hours for each employee.

Thank you in advance!

Chaitra