DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PAY_BALANCE_CONTEXT_VALUES

Object Details
Object Name: PAY_BALANCE_CONTEXT_VALUES
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_BALANCE_CONTEXT_VALUES
Subobject Name:
Status: VALID


PAY_BALANCE_CONTEXT_VALUES holds localization context values which,
together with a specific assignment action and defined balance
combination, uniquely determine a specific latest balance.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_BALANCE_CONTEXT_VALUES_PK
  1. ColumnLATEST_BALANCE_ID
  2. ColumnCONTEXT_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_BALANCE_CONTEXT_VALUES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLATEST_BALANCE_ID
ColumnCONTEXT_ID
PAY_BALANCE_CONTEXT_VALUES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTEXT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_BALANCE_CONTEXT_VALUES PAY_BALANCE_CONTEXT_VALUES_FK1 TableFF_CONTEXTS PAY_BALANCE_CONTEXT_VALUES CONTEXT_ID
Columns
Name Datatype Length Mandatory Comments
CONTEXT_ID NUMBER (9) Yes Foreign key to FF_CONTEXTS.
LATEST_BALANCE_ID NUMBER (9) Yes Foreign key to either PAY_PERSON_LATEST_BALANCES or PAY_ASSIGNMENT_LATEST_BALANCES.
VALUE VARCHAR2 (60) Yes Value of the context.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONTEXT_ID
,      LATEST_BALANCE_ID
,      VALUE
FROM HR.PAY_BALANCE_CONTEXT_VALUES;

Dependencies

[top of page]

HR.PAY_BALANCE_CONTEXT_VALUES does not reference any database object

HR.PAY_BALANCE_CONTEXT_VALUES is referenced by following:

SchemaAPPS
SynonymPAY_BALANCE_CONTEXT_VALUES
SchemaPUBLIC
SynonymPAY_BALANCE_CONTEXT_VALUES