[Home] [Help] [Dependency Information]
Object Name: | PAY_JP_WL_YEA_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_JP_WL_YEA_INFO_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ACTION_INFORMATION_ID | NUMBER | (15) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | |||
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
ACTION_CONTEXT_TYPE | VARCHAR2 | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | ||
EFFECTIVE_DATE | DATE | |||
ACTION_INFORMATION_CATEGORY | VARCHAR2 | (80) | Yes | |
PERSON_ID | NUMBER | |||
SAL_AMT | NUMBER | |||
BON_AMT | NUMBER | |||
TAXABLE_INCOME | NUMBER | |||
SAL_TAX | NUMBER | |||
BON_TAX | NUMBER | |||
NET_INCOME | NUMBER | |||
SI_DEDUCTION | NUMBER | |||
SI_PREM | NUMBER | |||
DEP_EXEMPTION | NUMBER | |||
LI_PREM | NUMBER | |||
EI_PREM | NUMBER | |||
SPOUSE_SP_EXEMPT | NUMBER | |||
SPOUSE_INCOME | NUMBER | |||
PP_PREM | NUMBER | |||
LONG_TERM_AI_PREM | NUMBER | |||
MUTUAL_AID_PREM | NUMBER | |||
NPI_PREMIUM | NUMBER | |||
HOUSING_LOAN_DEDUCTION | NUMBER | |||
YEA_ANNUAL_TAX | NUMBER | |||
OVER_AND_SHORT_TAX | NUMBER | |||
DEP_SPOUSE_EXEMPTION | NUMBER | |||
DEPENDENT_EXEMPTION | NUMBER | |||
BASIS_EXEMPTION | NUMBER | |||
DEP_DISABLED_EXEMPTION | NUMBER | |||
TOTAL_SE_DE_BE_DISE | NUMBER | |||
TOTAL_INCOME_DEDUCTION | NUMBER | |||
NET_ASS_SAL_INCOME_MONEY | NUMBER | |||
CALCULATED_TAX | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ACTION_INFORMATION_ID
, OBJECT_VERSION_NUMBER
, ASSIGNMENT_ACTION_ID
, ACTION_CONTEXT_TYPE
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, ACTION_INFORMATION_CATEGORY
, PERSON_ID
, SAL_AMT
, BON_AMT
, TAXABLE_INCOME
, SAL_TAX
, BON_TAX
, NET_INCOME
, SI_DEDUCTION
, SI_PREM
, DEP_EXEMPTION
, LI_PREM
, EI_PREM
, SPOUSE_SP_EXEMPT
, SPOUSE_INCOME
, PP_PREM
, LONG_TERM_AI_PREM
, MUTUAL_AID_PREM
, NPI_PREMIUM
, HOUSING_LOAN_DEDUCTION
, YEA_ANNUAL_TAX
, OVER_AND_SHORT_TAX
, DEP_SPOUSE_EXEMPTION
, DEPENDENT_EXEMPTION
, BASIS_EXEMPTION
, DEP_DISABLED_EXEMPTION
, TOTAL_SE_DE_BE_DISE
, TOTAL_INCOME_DEDUCTION
, NET_ASS_SAL_INCOME_MONEY
, CALCULATED_TAX
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM APPS.PAY_JP_WL_YEA_INFO_V;
APPS.PAY_JP_WL_YEA_INFO_V is not referenced by any database object
|
|
|