SQL Query to get Employee's Absence Accrual BASIC entitled Balance and Carryover
Hi,
I need a query to get employee's absence accrual BASIC entitlement value which he/she gets at first day of hire on the application.
Please note that:
First: I know that I can get the accrual net entitlement from db standard function PER_UTILITY_FUNCTIONS.GET_NET_ACCRUAL. This is not what I'm looking for. what I need is to know where in the database stored the BASIC accrual value which is can be viewed on the application from accrual window screen below or how I can get throw a db query.
Second: There is no payroll implemented so accrual balance has NULL value when retrieved.