Leave Balance Calculation date showing different than UI in BIP report

Summary:

Hi Team,

Leave Balance Caluclation date showing diffrent than UI in BIP report

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Select papf.person_number Person_id, 

    ppnf.FULL_NAME,

    papf1.person_number Manager_number,

    ppnf1.FULL_NAME Manager_Name,

    to_char(ppos.ORIGINAL_DATE_OF_HIRE,'MM-DD-YYYY') Enterprise_Hire_Date,

    aapft.NAME Plan_Name, 

    to_char(apae.ACCRUAL_PERIOD,'MM-DD-YYYY') Balance_End_Date,

  apae.END_BAL current_balance,

  haou.name Legal_Employer               

from PER_PERSON_SECURED_LIST_V papf,

   PER_PERSON_NAMES_F ppnf,