[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_KR_SEP_TAX_V

Object Details

Object Name:	PAY_KR_SEP_TAX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_KR_SEP_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 BUSINESS_GROUP_ID
,      PAYROLL_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_ACTION_ID
,      PAYROLL_ACTION_ID
,      EFFECTIVE_DATE
,      DATE_EARNED
,      XEFFECTIVE_DATE
,      RUN_TYPE_ID
,      RUN_TYPE_NAME
,      TAX_UNIT_ID
,      XASSIGNMENT_ACTION_ID
,      XPAYROLL_ACTION_ID
,      PREV_ELEMENT_ENTRY_ID
,      PREV_BP_NUMBER
,      PREV_BP_NAME
,      PREV_SEP_PAY
,      PREV_SEP_INS
,      PREV_SP_SEP_ALW
,      PREV_ELIGIBLE_FOR_PTAX
,      PREV_SP_NON_TAX_AMT
,      BP_NUMBER
,      CORP_NAME
,      CORP_REPRESENTATIVE_NAME
,      CORP_NUMBER
,      BP_ADDRESS
,      TAX_OFFICE_NAME
,      LAST_NAME
,      FIRST_NAME
,      NATIONAL_IDENTIFIER
,      PERSON_ADDRESS
,      NATIONALITY
,      HIRING_DATE
,      LEAVING_DATE
,      PREV_FIRST_HIRING_DATE
,      PREV_LAST_LEAVING_DATE
,      COUNTRY_CODE
,      COUNTRY
,      ACTUAL_TERMINATION_DATE
,      PERSON_ID
,      SEP_PAY_OVERSEAS_TAX_BREAK
,      NON_STAT_SEP_OVERSEAS_TAX_BRK
,      STAT_SEP_PAY_POST_TAX_DEDUC
,      NON_STAT_SEP_POST_TAX_DEDUC
FROM APPS.PAY_KR_SEP_TAX_V;

Dependencies

[top of page]

APPS

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PAY_KR_REPORT_PKG - show dependent code

PAY_KR_SEP_FORM_PKG - show dependent code

PAY_KR_SEP_TAX_WO_ADDR_V

PER_ADDRESSES

APPS

PAY_KR_NONSTAT_SPAY_EFILE_FUN - show dependent code