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

TABLE: HR.PAY_US_TAX_REPORT_BALANCES

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


PAY_US_TAX_REPORT_BALANCES holds the list of tax balances reported by
the Tax Summary Listing report.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 20
PCT Used:
Primary Key: PAY_US_TAX_REPORT_BALANCES_PK
  1. ColumnREPORT_CODE
  2. ColumnTAX_BALANCE_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_US_TAX_REPORT_BALANCES_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnREPORT_CODE
ColumnTAX_BALANCE_ID
PAY_US_TAX_REPORT_BALANCES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnTAX_BALANCE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_US_TAX_REPORT_BALANCES PAY_US_TAX_REPORT_BALANCES_FK1 TablePAY_US_TAX_BALANCES PAY_US_TAX_REPORT_BALANCES TAX_BALANCE_ID
Columns
Name Datatype Length Mandatory Comments
REPORT_CODE VARCHAR2 (30) Yes Code representing the list of balances and balance dimensions to be reported.
TAX_BALANCE_ID NUMBER (9) Yes Foreign key to PAY_US_TAX_BALANCES.
BALANCE_PRINT_SEQUENCE NUMBER (9)
User defined sequence for printing the balances.
Query Text

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


SELECT REPORT_CODE
,      TAX_BALANCE_ID
,      BALANCE_PRINT_SEQUENCE
FROM HR.PAY_US_TAX_REPORT_BALANCES;

Dependencies

[top of page]

HR.PAY_US_TAX_REPORT_BALANCES does not reference any database object

HR.PAY_US_TAX_REPORT_BALANCES is referenced by following:

SchemaAPPS
SynonymPAY_US_TAX_REPORT_BALANCES
SchemaPUBLIC
SynonymPAY_US_TAX_REPORT_BALANCES