SQL to fetch the qualified entitlements “Used” column

Summary:

Hi,

I am currently trying to fetch the qualified entitlements  “Used”  column from the system and have referred to the table ANC_PER_ABS_QUAL_ENTL, specifically the column PLAN_PERIOD_USED_ENTL. However, this is returning 0, which does not match the data shown in the application.Has anyone encountered a similar requirement.

Using this SQL query, which is giving 0 value, even though data is present that is 7.8

SELECT SUM(NVL(B.PLAN_PERIOD_USED_ENTL, 0))
FROM ANC_PER_ABS_QUAL_ENTL B,
ANC_ABSENCE_PLANS_VL APV,
ANC_ABSENCE_TYPE_PLANS_F ATP,
ANC_ABSENCE_TYPES_VL AATVL