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.PAY_EMP_FED_TAX_V1

Object Details

Object Name:	PAY_EMP_FED_TAX_V1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_EMP_FED_TAX_V1
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
ROW_ID	ROWID	(10)
ASSIGNMENT_EXTRA_INFO_ID	NUMBER	(15)	Yes
ASSIGNMENT_ID	NUMBER	(10)	Yes
INFORMATION_TYPE	VARCHAR2	(40)	Yes
WITHHOLDING_ALLOWANCES	NUMBER
ADDITIONAL_WA_AMOUNT	NUMBER
EXCESSIVE_WA_REJECT_DATE	DATE
FILING_STATUS_CODE	VARCHAR2	(150)
FILING_STATUS	VARCHAR2	(80)	Yes
FIT_ADDITIONAL_TAX	NUMBER
FIT_EXEMPT	VARCHAR2	(150)
MEDICARE_TAX_EXEMPT	VARCHAR2	(150)
SS_TAX_EXEMPT	VARCHAR2	(150)
FUTA_TAX_EXEMPT	VARCHAR2	(150)
STATUTORY_EMPLOYEE	VARCHAR2	(150)
CUMULATIVE_TAXATION	VARCHAR2	(150)
EIC_FILING_STATUS_CODE	VARCHAR2	(150)
EIC_FILING_STATUS	VARCHAR2	(80)	Yes
W2_FILED_YEAR	VARCHAR2	(150)
FIT_OVERRIDE_RATE	NUMBER
FIT_OVERRIDE_AMOUNT	NUMBER
RESIDENT_STATE_CODE	VARCHAR2	(150)
SUPP_TAX_OVERRIDE_RATE	NUMBER
SUI_JURISDICTION_CODE	VARCHAR2	(150)
SUI_STATE_CODE	VARCHAR2	(2)	Yes
SUI_STATE_NAME	VARCHAR2	(50)	Yes
RESIDENT_LOCALITY	VARCHAR2	(150)
WORK_LOCALITY	VARCHAR2	(150)

Query Text

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


SELECT ROW_ID
,      ASSIGNMENT_EXTRA_INFO_ID
,      ASSIGNMENT_ID
,      INFORMATION_TYPE
,      WITHHOLDING_ALLOWANCES
,      ADDITIONAL_WA_AMOUNT
,      EXCESSIVE_WA_REJECT_DATE
,      FILING_STATUS_CODE
,      FILING_STATUS
,      FIT_ADDITIONAL_TAX
,      FIT_EXEMPT
,      MEDICARE_TAX_EXEMPT
,      SS_TAX_EXEMPT
,      FUTA_TAX_EXEMPT
,      STATUTORY_EMPLOYEE
,      CUMULATIVE_TAXATION
,      EIC_FILING_STATUS_CODE
,      EIC_FILING_STATUS
,      W2_FILED_YEAR
,      FIT_OVERRIDE_RATE
,      FIT_OVERRIDE_AMOUNT
,      RESIDENT_STATE_CODE
,      SUPP_TAX_OVERRIDE_RATE
,      SUI_JURISDICTION_CODE
,      SUI_STATE_CODE
,      SUI_STATE_NAME
,      RESIDENT_LOCALITY
,      WORK_LOCALITY
FROM APPS.PAY_EMP_FED_TAX_V1;

Dependencies

[top of page]

APPS.PAY_EMP_FED_TAX_V1 references the following:

APPS: FND_DATE - show dependent code; FND_NUMBER - show dependent code; HR_API - show dependent code; HR_LOOKUPS; PAY_STATE_RULES; PER_ASSIGNMENT_EXTRA_INFO

APPS.PAY_EMP_FED_TAX_V1 is referenced by following:

APPS: HR_SCL_FLEX - show dependent code; PAY_US_EMP_TAX_RULES_PKG - show dependent code