Human Capital Management - EBS (MOSC)

MOSC Banner

SQL Query to get Employee's Absence Accrual BASIC entitled Balance and Carryover

edited Jun 18, 2020 7:46AM in Human Capital Management - EBS (MOSC) 7 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center