[Home] [Help] [Dependency Information]
Object Name: | PAY_KR_PREV_ER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_KR_PREV_ER_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ASSIGNMENT_EXTRA_INFO_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
INFORMATION_TYPE | VARCHAR2 | (40) | Yes | |
AEI_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
TERMINATION_DATE | DATE | |||
BP_NAME | VARCHAR2 | (150) | ||
BP_NUMBER | VARCHAR2 | (150) | ||
TAXABLE_EARNINGS_MTH | NUMBER | |||
TAXABLE_EARNINGS_BON | NUMBER | |||
SP_IRREG_BONUS | NUMBER | |||
NON_TAXABLE_OVS_EARNINGS | NUMBER | |||
NON_TAXABLE_OVT_EARNINGS | NUMBER | |||
NON_TAXABLE_OTH_EARNINGS | NUMBER | |||
HI_PREM | NUMBER | |||
EI_PREM | NUMBER | |||
NP_PREM | NUMBER | |||
ITAX | NUMBER | |||
RTAX | NUMBER | |||
STAX | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ASSIGNMENT_EXTRA_INFO_ID
, ASSIGNMENT_ID
, INFORMATION_TYPE
, AEI_INFORMATION_CATEGORY
, OBJECT_VERSION_NUMBER
, TERMINATION_DATE
, BP_NAME
, BP_NUMBER
, TAXABLE_EARNINGS_MTH
, TAXABLE_EARNINGS_BON
, SP_IRREG_BONUS
, NON_TAXABLE_OVS_EARNINGS
, NON_TAXABLE_OVT_EARNINGS
, NON_TAXABLE_OTH_EARNINGS
, HI_PREM
, EI_PREM
, NP_PREM
, ITAX
, RTAX
, STAX
FROM APPS.PAY_KR_PREV_ER_V;
APPS.PAY_KR_PREV_ER_V is not referenced by any database object
|
|
|