eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.PAY_TEMP_BALANCE_ADJUSTMENTS

Object Details

Object Name:	PAY_TEMP_BALANCE_ADJUSTMENTS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_TEMP_BALANCE_ADJUSTMENTS
Subobject Name:
Status:	VALID

PAY_TEMP_BALANCE_ADJUSTMENTS is used as a temporary storage area for
the balance initialization process. It holds the specific adjustment
values for each balance dimension, so that the cumulative value for
that balance dimension is correctly set. Once the processing is
complete, the rows inserted in the table are removed.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_TEMP_BALANCE_ADJUST_FK1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	BATCH_LINE_ID
PAY_TEMP_BALANCE_ADJUST_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	BALANCE_TYPE_ID ADJUSTMENT_DATE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_TEMP_BALANCE_ADJUSTMENTS		PAY_BALANCE_BATCH_LINES	PAY_TEMP_BALANCE_ADJUSTMENTS BATCH_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BALANCE_TYPE_ID	NUMBER	(9)		Foreign key to PAY_BALANCE_TYPES.
BALANCE_DIMENSION_ID	NUMBER	(9)		Foreign key to PAY_BALANCE_DIMENSIONS.
ELEMENT_LINK_ID	NUMBER	(9)		Foreign key to PAY_ELEMENT_LINKS_F.
JC_INPUT_VALUE_ID	NUMBER	(9)		Foreign key to PAY_INPUT_VALUES_F.
IBF_INPUT_VALUE_ID	NUMBER	(9)		Foreign key to PAY_INPUT_VALUES_F.
TAX_UNIT_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
BATCH_LINE_ID	NUMBER	(9)	Yes	Foreign key to PAY_BALANCE_BATCH_LINES.
ADJUSTMENT_AMOUNT	NUMBER			The value by which the balance needs to be adjusted.
ADJUSTMENT_DATE	DATE			The date on which the balance needs to be adjusted.
EXPIRY_DATE	DATE			Date balance expires.
JURISDICTION_CODE	VARCHAR2	(30)		This is a geographical location context to the balance.
ORIGINAL_ENTRY_ID	NUMBER			Foreign key to PAY_ELEMENT_ENTRIES_F.
SOURCE_ID	NUMBER	(15)		Context of Source id
SOURCE_TEXT	VARCHAR2	(60)		Context of Source Text
RUN_TYPE_ID	NUMBER	(9)		Foreign key to PAY_RUN_TYPES_F.
SOURCE_NUMBER	NUMBER			Context of Source Number
SOURCE_TEXT2	VARCHAR2	(60)		Context of Source Text2

Query Text

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


SELECT BALANCE_TYPE_ID
,      BALANCE_DIMENSION_ID
,      ELEMENT_LINK_ID
,      JC_INPUT_VALUE_ID
,      IBF_INPUT_VALUE_ID
,      TAX_UNIT_ID
,      BATCH_LINE_ID
,      ADJUSTMENT_AMOUNT
,      ADJUSTMENT_DATE
,      EXPIRY_DATE
,      JURISDICTION_CODE
,      ORIGINAL_ENTRY_ID
,      SOURCE_ID
,      SOURCE_TEXT
,      RUN_TYPE_ID
,      SOURCE_NUMBER
,      SOURCE_TEXT2
FROM HR.PAY_TEMP_BALANCE_ADJUSTMENTS;

Dependencies

[top of page]

HR.PAY_TEMP_BALANCE_ADJUSTMENTS does not reference any database object

HR.PAY_TEMP_BALANCE_ADJUSTMENTS is referenced by following:

APPS: PAY_TEMP_BALANCE_ADJUSTMENTS
PUBLIC: PAY_TEMP_BALANCE_ADJUSTMENTS