[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_KR_SEP_RESULT_TAX_V

Object Details

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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;

Dependencies

[top of page]

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