[Home] [Help] [Dependency Information]
Object Name: | PAY_KR_SEP_RESULT_TAX_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_KR_SEP_RESULT_TAX_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | ||
EFFECTIVE_DATE | DATE | Yes | ||
DATE_EARNED | DATE | |||
RUN_TYPE_ID | NUMBER | (9) | ||
HIRING_DATE | DATE | |||
LEAVING_DATE | DATE | |||
WORKING_PERIOD | NUMBER | |||
WKPD_SEP_TAX | VARCHAR2 | (4000) | ||
PREV_FIRST_HIRING_DATE | DATE | |||
PREV_LAST_LEAVING_DATE | DATE | |||
NS_HIRING_DATE | DATE | |||
NS_LEAVING_DATE | DATE | |||
NS_PREV_FIRST_HIRING_DATE | DATE | |||
NS_PREV_LAST_LEAVING_DATE | DATE | |||
PREV_WKPD_SEP_TAX | VARCHAR2 | (4000) | ||
OVERLAP_WKPD | VARCHAR2 | (4000) | ||
SERVICE_PERIOD | VARCHAR2 | (4000) | ||
SEP_PAY | VARCHAR2 | (4000) | ||
SEP_INS | VARCHAR2 | (4000) | ||
SP_SEP_ALW | VARCHAR2 | (4000) | ||
TOTAL_TAXABLE_EARNINGS | VARCHAR2 | (4000) | ||
TAXABLE_EARNINGS_WI_PREV | VARCHAR2 | (4000) | ||
INCOME_EXEM | VARCHAR2 | (4000) | ||
TAXATION_BASE | VARCHAR2 | (4000) | ||
YTAXATION_BASE | VARCHAR2 | (4000) | ||
YCALC_TAX | VARCHAR2 | (4000) | ||
CALC_TAX | VARCHAR2 | (4000) | ||
TAX_BREAK | VARCHAR2 | (4000) | ||
ACTUAL_TAX | VARCHAR2 | (4000) | ||
GROSS_ITAX | VARCHAR2 | (4000) | ||
GROSS_RTAX | VARCHAR2 | (4000) | ||
GROSS_STAX | VARCHAR2 | (4000) | ||
ITAX | VARCHAR2 | (4000) | ||
RTAX | VARCHAR2 | (4000) | ||
STAX | VARCHAR2 | (4000) | ||
NS_SEP_PAY_AMT | VARCHAR2 | (4000) | ||
NS_WKPD_SEP_TAX | VARCHAR2 | (4000) | ||
NS_PREV_WKPD_SEP_TAX | VARCHAR2 | (4000) | ||
NS_OVERLAP_WKPD | VARCHAR2 | (4000) | ||
NS_SEP_PAY_INCOME_EXEM | VARCHAR2 | (4000) | ||
NS_SVPD_INCOME_EXEM | VARCHAR2 | (4000) | ||
NS_TAXATION_BASE | VARCHAR2 | (4000) | ||
NS_SERVICE_PERIOD | VARCHAR2 | (4000) | ||
NS_YTAXATION_BASE | VARCHAR2 | (4000) | ||
NS_YCALC_TAX | VARCHAR2 | (4000) | ||
NS_CALC_TAX | VARCHAR2 | (4000) | ||
NS_TAX_BREAK | VARCHAR2 | (4000) | ||
NS_ACTUAL_TAX | VARCHAR2 | (4000) | ||
PREV_SEP_PAY | VARCHAR2 | (4000) | ||
PREV_SEP_INS | VARCHAR2 | (4000) | ||
PREV_SP_SEP_ALW | VARCHAR2 | (4000) | ||
NS_EXCLUDED_MTH | VARCHAR2 | (4000) | ||
SEP_PEN_LUMP_SUM_AMT | VARCHAR2 | (4000) | ||
RECEIVABLE_SEP_PAY | VARCHAR2 | (4000) | ||
TOTAL_LUMP_SUM_AMT | VARCHAR2 | (4000) | ||
TOTAL_RECEIVED | VARCHAR2 | (4000) | ||
PRINCIPAL_INTEREST | VARCHAR2 | (4000) | ||
PERSONAL_CONTRIBUTION | VARCHAR2 | (4000) | ||
PENSION_EXEM | VARCHAR2 | (4000) | ||
AMT_EXP | VARCHAR2 | (4000) | ||
EXCLUDED_MTH | VARCHAR2 | (4000) | ||
SEP_PEN_LUMP_SUM_NON_TAX_AMT | VARCHAR2 | (4000) | ||
PREV_NON_TAX_EAR | VARCHAR2 | (4000) | ||
OVERSEAS_TAX_BREAK | NUMBER | |||
NS_OVERSEAS_TAX_BREAK | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ACTION_ID
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, DATE_EARNED
, RUN_TYPE_ID
, HIRING_DATE
, LEAVING_DATE
, WORKING_PERIOD
, WKPD_SEP_TAX
, PREV_FIRST_HIRING_DATE
, PREV_LAST_LEAVING_DATE
, NS_HIRING_DATE
, NS_LEAVING_DATE
, NS_PREV_FIRST_HIRING_DATE
, NS_PREV_LAST_LEAVING_DATE
, PREV_WKPD_SEP_TAX
, OVERLAP_WKPD
, SERVICE_PERIOD
, SEP_PAY
, SEP_INS
, SP_SEP_ALW
, TOTAL_TAXABLE_EARNINGS
, TAXABLE_EARNINGS_WI_PREV
, INCOME_EXEM
, TAXATION_BASE
, YTAXATION_BASE
, YCALC_TAX
, CALC_TAX
, TAX_BREAK
, ACTUAL_TAX
, GROSS_ITAX
, GROSS_RTAX
, GROSS_STAX
, ITAX
, RTAX
, STAX
, NS_SEP_PAY_AMT
, NS_WKPD_SEP_TAX
, NS_PREV_WKPD_SEP_TAX
, NS_OVERLAP_WKPD
, NS_SEP_PAY_INCOME_EXEM
, NS_SVPD_INCOME_EXEM
, NS_TAXATION_BASE
, NS_SERVICE_PERIOD
, NS_YTAXATION_BASE
, NS_YCALC_TAX
, NS_CALC_TAX
, NS_TAX_BREAK
, NS_ACTUAL_TAX
, PREV_SEP_PAY
, PREV_SEP_INS
, PREV_SP_SEP_ALW
, NS_EXCLUDED_MTH
, SEP_PEN_LUMP_SUM_AMT
, RECEIVABLE_SEP_PAY
, TOTAL_LUMP_SUM_AMT
, TOTAL_RECEIVED
, PRINCIPAL_INTEREST
, PERSONAL_CONTRIBUTION
, PENSION_EXEM
, AMT_EXP
, EXCLUDED_MTH
, SEP_PEN_LUMP_SUM_NON_TAX_AMT
, PREV_NON_TAX_EAR
, OVERSEAS_TAX_BREAK
, NS_OVERSEAS_TAX_BREAK
FROM APPS.PAY_KR_SEP_RESULT_TAX_V;
|
|
|