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

TABLE: HR.PAY_ZA_TAXREG_BAL_TEMP

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


Table holds balance types for specific assignments


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_ZA_TAXREG_BAL_TEMP_PK
  1. ColumnBALANCE_TYPE_ID
  2. ColumnASSIGNMENT_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_ZA_TAXREG_BAL_TEMP_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBALANCE_TYPE_ID
ColumnASSIGNMENT_ID
Columns
Name Datatype Length Mandatory Comments
BALANCE_TYPE_ID NUMBER (9) Yes Tax Balance Type ID
ASSIGNMENT_ID NUMBER (9) Yes Assignment ID
Query Text

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


SELECT BALANCE_TYPE_ID
,      ASSIGNMENT_ID
FROM HR.PAY_ZA_TAXREG_BAL_TEMP;

Dependencies

[top of page]

HR.PAY_ZA_TAXREG_BAL_TEMP does not reference any database object

HR.PAY_ZA_TAXREG_BAL_TEMP is referenced by following:

SchemaAPPS
SynonymPAY_ZA_TAXREG_BAL_TEMP
SchemaPUBLIC
SynonymPAY_ZA_TAXREG_BAL_TEMP