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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view returns a list of the state filing status codes as used in Oracle HRMS. It can be used during the implementation of the ADP payroll interface.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STATE_CODE	VARCHAR2	(2)	Yes	State abbreviation
LOOKUP_CODE	VARCHAR2	(30)	Yes	State filing status code
MEANING	VARCHAR2	(80)	Yes	State filing status

Query Text

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


SELECT STATE_CODE
,      LOOKUP_CODE
,      MEANING
FROM APPS.HR_ADP_STATE_TAX_CODES_V;

Dependencies

[top of page]

APPS.HR_ADP_STATE_TAX_CODES_V references the following:

APPS: HR_API - show dependent code; HR_LOOKUPS; PAY_STATE_RULES

APPS.HR_ADP_STATE_TAX_CODES_V is not referenced by any database object