[Home] [Help]
[Dependency Information]
VIEW: HR.PAY_US_ASG_REPORTING#
Object Details
Object Name: | PAY_US_ASG_REPORTING# |
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ASSIGNMENT_ID |
NUMBER |
(10) |
|
|
EFFECTIVE_START_DATE |
DATE |
|
|
|
EFFECTIVE_END_DATE |
DATE |
|
|
|
JURISDICTION_CODE |
VARCHAR2 |
(30) |
|
|
TAX_UNIT_ID |
NUMBER |
(15) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, JURISDICTION_CODE
, TAX_UNIT_ID
FROM HR.PAY_US_ASG_REPORTING#;
Dependencies
[top of page]
HR.PAY_US_ASG_REPORTING# references the following:
-
HR
-
PAY_US_ASG_REPORTING
HR.PAY_US_ASG_REPORTING# is referenced by following:
-
APPS
-
PAY_US_ASG_REPORTING