!!Get Employee AAL_TODATE

!Functionality:
The purpose of this function is to capture the values from the [IALA] "Previous Evaluations" tab that have been processed within the date range specified.


!Parameters:

|EEM_ID        |''Required''.The [EEM_ID] from [P2K_HR_EMPLOYMENTS] belonging to the employee to be processed
|LEAVE_TYPE    |''Required''.The [LEAVE_TYPE_CODE] defined on [P2K_AT_LEAVE_POLICY_TYPES] in which leave lines are to be captured
|AC_CODE       |''Required''.The [AC_CODE] as defined on [P2K_AT_ATTENDANCE_COMPONENTS] (ie, A290,A300,etc.)
|START         |''Optional'' The earliest start date from the [P2K_AT_LEAVE_LINES]to be included. (Sysdate will be used if left blank)
|END           |''Optional'' The latest end date from the [P2K_AT_LEAVE_LINES] to be included. (Sysdate will be used if left blank)


!Returns: 
Numeric

!Errors:  
* When No Data is found than 0 will be returned
* When there is an undetermined exception than -1 will be returned

!Example: 

FUNCTION AAL_TODATE (~,'VACATION','A290','01-Jan-2017','31-Jan-2017')

Will return leave lines values linked to the leave type 'VACATION' and the AC_CODE A290 that can be seen on the IALA leave history tab that have a [START_DATE] that falls between '01-Jan-2017 and 31-Jan-2017'


FUNCTION AAL_TODATE (~,'VACATION')

Will return leave lines values linked to the leave type 'VACATION' and the AC_CODE A300 that can be seen on the IALA leave history tab that have a [START_DATE] that falls on the current system date


FUNCTION AAL_TODATE (~,'SICK','A290','01-Dec-2017')

Will return leave lines values linked to the leave type 'SICK' and the AC_CODE A300 that can be seen on the IALA leave history tab that have a [START_DATE] that falls between '01-DEC-2017' and the current system date

!Notes
* The EEM_ID will be used to check leave lines details for the value of the specified AC code for the leave type as of the listed date.
* This will be to return the accumulated values as seen in the Previous Evaluations tab of IALA.
* This should not be used for capturing AC codes that report to_date values (like A700) as they will be summarized and incorrect
* Only leave lines without Time Codes will be picked up
* Only Leave lines with an accrual status not in 3-In Payroll, 1-Requested or 2-Requested Processed will be picked up

----
![Notes|Edit:Internal.GET_EID]
[{InsertPage page='Internal.P2K_PU.DES_TYPE' default='Click to create a new notes page'}]