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

VIEW: HR.PAY_LATEST_BALANCES#

Object Details
Object Name: PAY_LATEST_BALANCES#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LATEST_BALANCE_ID NUMBER (15) Yes
DEFINED_BALANCE_ID NUMBER (9) Yes
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
VALUE NUMBER (38) Yes
PERSON_ID NUMBER (10) Yes
ASSIGNMENT_ID NUMBER (10)
EXPIRY_DATE DATE

EXPIRED_ASSIGNMENT_ACTION_ID NUMBER (15)
EXPIRED_VALUE NUMBER (38)
EXPIRED_DATE DATE

PREV_ASSIGNMENT_ACTION_ID NUMBER (15)
PREV_BALANCE_VALUE NUMBER (38)
PREV_EXPIRY_DATE DATE

TAX_UNIT_ID NUMBER (15)
JURISDICTION_CODE VARCHAR2 (30)
ORIGINAL_ENTRY_ID NUMBER (15)
SOURCE_ID NUMBER (15)
SOURCE_TEXT VARCHAR2 (60)
SOURCE_TEXT2 VARCHAR2 (60)
SOURCE_NUMBER NUMBER

TAX_GROUP VARCHAR2 (60)
PAYROLL_ID NUMBER (9)
PROCESS_GROUP_ID NUMBER (10)
SOURCE_NUMBER2 NUMBER

LOCAL_UNIT_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15)
INSTANCE_ID NUMBER (9)
Query Text

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


SELECT LATEST_BALANCE_ID
,      DEFINED_BALANCE_ID
,      ASSIGNMENT_ACTION_ID
,      VALUE
,      PERSON_ID
,      ASSIGNMENT_ID
,      EXPIRY_DATE
,      EXPIRED_ASSIGNMENT_ACTION_ID
,      EXPIRED_VALUE
,      EXPIRED_DATE
,      PREV_ASSIGNMENT_ACTION_ID
,      PREV_BALANCE_VALUE
,      PREV_EXPIRY_DATE
,      TAX_UNIT_ID
,      JURISDICTION_CODE
,      ORIGINAL_ENTRY_ID
,      SOURCE_ID
,      SOURCE_TEXT
,      SOURCE_TEXT2
,      SOURCE_NUMBER
,      TAX_GROUP
,      PAYROLL_ID
,      PROCESS_GROUP_ID
,      SOURCE_NUMBER2
,      LOCAL_UNIT_ID
,      ORGANIZATION_ID
,      INSTANCE_ID
FROM HR.PAY_LATEST_BALANCES#;

Dependencies

[top of page]

HR.PAY_LATEST_BALANCES# references the following:

SchemaHR
TablePAY_LATEST_BALANCES
HR.PAY_LATEST_BALANCES# is referenced by following:

SchemaAPPS
SynonymPAY_LATEST_BALANCES