[Home] [Help]
[Dependency Information]
[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) | ||
| PENSION_DEFINED_TYPES | 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 | |||
| TOTAL_RECEIVED_PREV | VARCHAR2 | (4000) | ||
| PERSONAL_CONTRIBUTION_PREV | VARCHAR2 | (4000) | ||
| PRINCIPAL_AND_INTEREST_PREV | VARCHAR2 | (4000) | ||
| AMOUNT_EXPECTED_PREV | VARCHAR2 | (4000) | ||
| AMOUNT_EXP_NONSTAT_PREV | VARCHAR2 | (4000) | ||
| PENSION_EXEMPTION_PREV | VARCHAR2 | (4000) | ||
| DEFERRED_AMT_STAT_PREV | VARCHAR2 | (4000) | ||
| DEFERRED_AMT_NONSTAT_PREV | VARCHAR2 | (4000) | ||
| RECEIVED_AMT_STAT_PREV | VARCHAR2 | (4000) | ||
| RECEIVED_AMT_NONSTAT_PREV | VARCHAR2 | (4000) | ||
| SEP_PEN_ACCOUNT_NUMBER | VARCHAR2 | (4000) | ||
| DEFERRED_AMT_STAT | VARCHAR2 | (4000) | ||
| DEFERRED_AMT_NST | VARCHAR2 | (4000) | ||
| RECEIVED_AMT_STAT | VARCHAR2 | (4000) | ||
| RECEIVED_AMT_NST | VARCHAR2 | (4000) | ||
| AMT_EXP_NST | VARCHAR2 | (4000) | ||
| SEP_PEN_LUMP_SUM_AMOUNT_PREV | VARCHAR2 | (4000) | ||
| RECEIVABLE_NONSTAT_SEP_PAY | VARCHAR2 | (4000) | ||
| NS_TOTAL_LUMP_SUM_AMOUNT | VARCHAR2 | (4000) | ||
| PREV_SEP_PEN_NTAX_LSA | VARCHAR2 | (4000) | ||
| PREV_SEP_PEN_LSA | VARCHAR2 | (4000) | ||
| SEP_PEN_LSA_STAT_ENT | VARCHAR2 | (4000) | ||
| SEP_PEN_LSA_NST_ENT | VARCHAR2 | (4000) | ||
| SEP_PEN_LSA_STAT_ENT_PREV | VARCHAR2 | (4000) | ||
| SEP_PEN_LSA_NST_ENT_PREV | VARCHAR2 | (4000) | ||
| POST_TAX_DEDUC | VARCHAR2 | (4000) | ||
| POST_TAX_DEDUC_NS | VARCHAR2 | (4000) | ||
| EXCEPTION_FLAG | VARCHAR2 | (4000) | ||
| SEP_PEN_ACCOUNT_NUMBER_PREV | VARCHAR2 | (4000) | ||
| PTAX_ELIGIBILITY_FLAG | VARCHAR2 | (4000) | ||
| SEP_PAY_REASON | VARCHAR2 | (4000) | ||
| SEP_PEN_ACCT_FIN_INST | VARCHAR2 | (4000) | ||
| TRANS_AMT_STAT | VARCHAR2 | (4000) | ||
| TRANS_AMT_NST | VARCHAR2 | (4000) | ||
| DEFERRED_TAX_AMT | VARCHAR2 | (4000) | ||
| WKPD_ADDTL_MTHS_STAT | VARCHAR2 | (4000) | ||
| WKPD_ADDTL_MTHS_NST | VARCHAR2 | (4000) | ||
| TRANS_DATE | VARCHAR2 | (11) | ||
| MATURITY_DATE | VARCHAR2 | (11) | ||
| PREV_ADDTL_MTH_NST | VARCHAR2 | (4000) | ||
| PREV_ADDTL_MTH_STAT | VARCHAR2 | (4000) | ||
| PREV_OVL_MTH_NST | VARCHAR2 | (4000) | ||
| PREV_OVL_MTH_STAT | VARCHAR2 | (4000) | ||
| PREV_WORK_YEAR_NST | VARCHAR2 | (4000) | ||
| PREV_WORK_YEAR_STAT | VARCHAR2 | (4000) | ||
| EXEC_SEP_PAY | VARCHAR2 | (4000) | ||
| TRANS_ACCOUNT_NUMBER | VARCHAR2 | (4000) | ||
| TRANS_FIN_INST | VARCHAR2 | (4000) |
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
, PENSION_DEFINED_TYPES
, AMT_EXP
, EXCLUDED_MTH
, SEP_PEN_LUMP_SUM_NON_TAX_AMT
, PREV_NON_TAX_EAR
, OVERSEAS_TAX_BREAK
, NS_OVERSEAS_TAX_BREAK
, TOTAL_RECEIVED_PREV
, PERSONAL_CONTRIBUTION_PREV
, PRINCIPAL_AND_INTEREST_PREV
, AMOUNT_EXPECTED_PREV
, AMOUNT_EXP_NONSTAT_PREV
, PENSION_EXEMPTION_PREV
, DEFERRED_AMT_STAT_PREV
, DEFERRED_AMT_NONSTAT_PREV
, RECEIVED_AMT_STAT_PREV
, RECEIVED_AMT_NONSTAT_PREV
, SEP_PEN_ACCOUNT_NUMBER
, DEFERRED_AMT_STAT
, DEFERRED_AMT_NST
, RECEIVED_AMT_STAT
, RECEIVED_AMT_NST
, AMT_EXP_NST
, SEP_PEN_LUMP_SUM_AMOUNT_PREV
, RECEIVABLE_NONSTAT_SEP_PAY
, NS_TOTAL_LUMP_SUM_AMOUNT
, PREV_SEP_PEN_NTAX_LSA
, PREV_SEP_PEN_LSA
, SEP_PEN_LSA_STAT_ENT
, SEP_PEN_LSA_NST_ENT
, SEP_PEN_LSA_STAT_ENT_PREV
, SEP_PEN_LSA_NST_ENT_PREV
, POST_TAX_DEDUC
, POST_TAX_DEDUC_NS
, EXCEPTION_FLAG
, SEP_PEN_ACCOUNT_NUMBER_PREV
, PTAX_ELIGIBILITY_FLAG
, SEP_PAY_REASON
, SEP_PEN_ACCT_FIN_INST
, TRANS_AMT_STAT
, TRANS_AMT_NST
, DEFERRED_TAX_AMT
, WKPD_ADDTL_MTHS_STAT
, WKPD_ADDTL_MTHS_NST
, TRANS_DATE
, MATURITY_DATE
, PREV_ADDTL_MTH_NST
, PREV_ADDTL_MTH_STAT
, PREV_OVL_MTH_NST
, PREV_OVL_MTH_STAT
, PREV_WORK_YEAR_NST
, PREV_WORK_YEAR_STAT
, EXEC_SEP_PAY
, TRANS_ACCOUNT_NUMBER
, TRANS_FIN_INST
FROM APPS.PAY_KR_SEP_RESULT_TAX_V;
APPS
HR_GENERAL
- show dependent code
PAY_ACTION_INTERLOCKS
PAY_ASSIGNMENT_ACTIONS
PAY_KR_REPORT_PKG
- show dependent code
PAY_PAYROLL_ACTIONS
PAY_RUN_TYPES_F
APPS.PAY_KR_SEP_RESULT_TAX_V is not referenced by any database object
|
|
|
|