[Home] [Help]
[Dependency Information]
| Object Name: | HRFV_ACCRUAL_VALUES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PER.HRFV_ACCRUAL_VALUES
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This view shows latest balances for those accrual plans to which
employees are currently enrolled.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BUSINESS_GROUP_NAME | VARCHAR2 | (240) | ||
| PERSON_NAME | VARCHAR2 | (240) | ||
| ACCRUAL_PLAN_NAME | VARCHAR2 | (80) | ||
| ACCRUAL_VALUE | NUMBER | |||
| ACCRUAL_UNITS | VARCHAR2 | (4000) | ||
| ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
| ACCRUAL_COMPONENT | VARCHAR2 | (4000) | ||
| ORDER_NUMBER | NUMBER | |||
| ACCRUAL_PLAN_ID | NUMBER | (9) | ||
| ASSIGNMENT_ID | NUMBER | (10) | ||
| BUSINESS_GROUP_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, PERSON_NAME
, ACCRUAL_PLAN_NAME
, ACCRUAL_VALUE
, ACCRUAL_UNITS
, ASSIGNMENT_NUMBER
, ACCRUAL_COMPONENT
, ORDER_NUMBER
, ACCRUAL_PLAN_ID
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
FROM APPS.HRFV_ACCRUAL_VALUES;
APPS
HR_ALL_ORGANIZATION_UNITS_TL
HR_BIS
- show dependent code
HR_GENERAL
- show dependent code
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
PAY_ACCRUAL_PLANS
PAY_ELEMENT_ENTRIES_F
PAY_ELEMENT_ENTRIES_X
PAY_ELEMENT_LINKS_X
PAY_ELEMENT_TYPES_F
PAY_ELEMENT_TYPES_F_TL
PAY_ELEMENT_TYPES_X
PAY_INPUT_VALUES_X
PAY_NET_CALCULATION_RULES
PER_ASSIGNMENTS_X
PER_PEOPLE_X
PER_TIME_PERIODS
PER_VIEWS_PKG
- show dependent code
PUBLIC
DUAL
PUBLIC
HRFV_ACCRUAL_VALUES
|
|
|
|