[Home] [Help]
[Dependency Information]
VIEW: PSP.PSP_SALARY_CAPS_EFC#
Object Details
Object Name: | PSP_SALARY_CAPS_EFC# |
Object Type: | VIEW |
Owner: | PSP |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
EFC_ACTION_ID |
NUMBER |
|
Yes |
|
SALARY_CAP_ID |
NUMBER |
(15) |
Yes |
|
ANNUAL_SALARY_CAP |
NUMBER |
|
Yes |
|
CURRENCY_CODE |
VARCHAR2 |
(15) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT EFC_ACTION_ID
, SALARY_CAP_ID
, ANNUAL_SALARY_CAP
, CURRENCY_CODE
FROM PSP.PSP_SALARY_CAPS_EFC#;
Dependencies
[top of page]
PSP.PSP_SALARY_CAPS_EFC# references the following:
-
PSP
-
PSP_SALARY_CAPS_EFC
PSP.PSP_SALARY_CAPS_EFC# is referenced by following:
-
APPS
-
PSP_SALARY_CAPS_EFC