!!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')

Using the [EEM_ID] as the ~ parameter, this will return leave lines values linked to the [LEAVE_TYPE_CODE] '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')
Using the [EEM_ID] as the ~ parameter, this will return leave lines values linked to the [LEAVE_TYPE_CODE] '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')
Using the [EEM_ID] as the ~ parameter, this will return leave lines values linked to the [LEAVE_TYPE_CODE] '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 a [TIME_CODE] will be picked up
* Only Leave lines with an accrual status not with an [ACCRUAL_TYPE] of 3-In Payroll, 1-Requested or 2-Requested Processed will be picked up