You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Leave Balance showing incorrect IN Custom BIP report

Received Response
12
Views
6
Comments

Summary:

Hi Team,

Some of emplyoees showing incorrect leave balance that zero and some of have showing corret value .


Could you please assit on ?


Thanks

AJAY

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               

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!