Fetch employee number or Person ID when Line Manager adds absence

Summary:

Content (required):

Hi All,

We want an absence plan balance to be shown in a DFF on Add Absence page.

The absence plan should be of the employee whose absence is being added.

We have written a SQL query to get the balance in the DFF as listed below

SELECT paeim.AEI_ATTRIBUTE2 

 FROM PER_ALL_ASSIGNMENTS_M    paam,

    PER_assignment_EXTRA_INFO_m paeim,

    PER_ALL_PEOPLE_F       papf,

    Per_Users          per

WHERE   paam.ASSIGNMENT_ID = paeim.ASSIGNMENT_ID

    AND TRUNC (SYSDATE) BETWEEN paam.effective_start_date

                AND paam.effective_end_date

    AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date