[Home] [Help]
[Dependency Information]
| Object Name: | PAY_SG_EOY_BALANCES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PAY.PAY_SG_EOY_BALANCES_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| PERSON_ID | NUMBER | (10) | Yes | |
| ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
| ASSIGNMENT_ID | NUMBER | (10) | ||
| TAX_UNIT_ID | NUMBER | (15) | ||
| ACTION_SEQUENCE | NUMBER | (15) | ||
| DATE_EARNED | DATE | |||
| EFFECTIVE_DATE | DATE | Yes | ||
| YEAR | VARCHAR2 | (4) | ||
| PERIOD_NAME | VARCHAR2 | (70) | Yes | |
| BALANCE_NAME | VARCHAR2 | (80) | Yes | |
| REPORTING_NAME | VARCHAR2 | (80) | ||
| BALANCE_TYPE_ID | NUMBER | (9) | Yes | |
| PER_RUN_BAL | NUMBER | |||
| PER_YTD_BAL | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_ID
, PERSON_ID
, ASSIGNMENT_ACTION_ID
, ASSIGNMENT_ID
, TAX_UNIT_ID
, ACTION_SEQUENCE
, DATE_EARNED
, EFFECTIVE_DATE
, YEAR
, PERIOD_NAME
, BALANCE_NAME
, REPORTING_NAME
, BALANCE_TYPE_ID
, PER_RUN_BAL
, PER_YTD_BAL
FROM APPS.PAY_SG_EOY_BALANCES_V;
APPS
HR_GENERAL
- show dependent code
HR_SECURITY
- show dependent code
PAY_ASSIGNMENT_ACTIONS
PAY_BALANCE_DIMENSIONS
PAY_BALANCE_PKG
- show dependent code
PAY_BALANCE_TYPES
PAY_BALANCE_TYPES_TL
PAY_DEFINED_BALANCES
PAY_PAYROLL_ACTIONS
PER_ASSIGNMENTS_F
PER_TIME_PERIODS
APPS.PAY_SG_EOY_BALANCES_V is not referenced by any database object
|
|
|
|