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