eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PER_ES_TAX_DETAILS_V

Object Details

Object Name:	PER_ES_TAX_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_ES_TAX_DETAILS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROW Id
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment ID
ELEMENT_ENTRY_ID	NUMBER	(15)	Yes	Element Entry ID
ELEMENT_LINK_ID	NUMBER	(9)	Yes	Element Link ID
ELEMENT_TYPE_ID	NUMBER	(9)	Yes	Element Type ID
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
SCREEN_ENTRY_VALUE0	VARCHAR2	(60)		Screen Entry Value0
WORKER_STATUS	VARCHAR2	(4000)		Worker Status
SCREEN_ENTRY_VALUE1	VARCHAR2	(60)		Screen Entry Value1
PAYMENT_KEY	VARCHAR2	(4000)		Payment Key
SCREEN_ENTRY_VALUE2	VARCHAR2	(60)		Screen Entry Value2
SUB_PAYMENT_KEY	VARCHAR2	(4000)		Sub Payment Key
CHANGE_OF_RESIDENCY_DATE	VARCHAR2	(60)		Change of Residency Date
OTHER_SITUATION	VARCHAR2	(60)		Other Situation
TAX_WITHHOLDING_RATE	VARCHAR2	(60)		Tax Withholding Rate
EFFECTIVE_START_DATE	DATE		Yes	Effective Start Date
EFFECTIVE_END_DATE	DATE		Yes	Effective End Date

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ASSIGNMENT_ID
,      ELEMENT_ENTRY_ID
,      ELEMENT_LINK_ID
,      ELEMENT_TYPE_ID
,      OBJECT_VERSION_NUMBER
,      SCREEN_ENTRY_VALUE0
,      WORKER_STATUS
,      SCREEN_ENTRY_VALUE1
,      PAYMENT_KEY
,      SCREEN_ENTRY_VALUE2
,      SUB_PAYMENT_KEY
,      CHANGE_OF_RESIDENCY_DATE
,      OTHER_SITUATION
,      TAX_WITHHOLDING_RATE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
FROM APPS.PER_ES_TAX_DETAILS_V;

Dependencies

[top of page]

APPS.PER_ES_TAX_DETAILS_V references the following:

APPS: FND_SESSIONS; HR_GENERAL - show dependent code; PAY_ELEMENT_ENTRIES_F; PAY_ELEMENT_ENTRY_VALUES_F; PAY_ELEMENT_LINKS_F; PAY_ELEMENT_TYPES_F; PAY_INPUT_VALUES_F

APPS.PER_ES_TAX_DETAILS_V is referenced by following:

PUBLIC: PER_ES_TAX_DETAILS_V