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

VIEW: APPS.PAY_US_EMP_TIME_IN_STATE_V

Object Details
Object Name: PAY_US_EMP_TIME_IN_STATE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_US_EMP_TIME_IN_STATE_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
ASSIGNMENT_ID NUMBER (10) Yes
STATE_CODE VARCHAR2 (2) Yes
STATE_NAME VARCHAR2 (25) Yes
JURISDICTION_CODE VARCHAR2 (11) Yes
FILING_STATUS_CODE VARCHAR2 (30) Yes
MEANING VARCHAR2 (80) Yes
WITHHOLDING_ALLOWANCES NUMBER (3) Yes
SIT_ADDITIONAL_TAX NUMBER (11) Yes
SIT_OVERRIDE_AMOUNT NUMBER (11) Yes
SIT_OVERRIDE_RATE NUMBER (6) Yes
TIME_IN_STATE NUMBER

EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
Query Text

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


SELECT ASSIGNMENT_ID
,      STATE_CODE
,      STATE_NAME
,      JURISDICTION_CODE
,      FILING_STATUS_CODE
,      MEANING
,      WITHHOLDING_ALLOWANCES
,      SIT_ADDITIONAL_TAX
,      SIT_OVERRIDE_AMOUNT
,      SIT_OVERRIDE_RATE
,      TIME_IN_STATE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
FROM APPS.PAY_US_EMP_TIME_IN_STATE_V;

Dependencies

[top of page]

APPS.PAY_US_EMP_TIME_IN_STATE_V references the following:

SchemaAPPS
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_NUMBER - show dependent code
SynonymFND_SESSIONS
SynonymPAY_ELEMENT_ENTRIES_F
SynonymPAY_ELEMENT_ENTRY_VALUES_F
SynonymPAY_ELEMENT_LINKS_F
SynonymPAY_ELEMENT_TYPES_F
SynonymPAY_INPUT_VALUES_F
SynonymPAY_STATE_RULES
SynonymPAY_US_EMP_STATE_TAX_RULES_F
SynonymPAY_US_STATES
APPS.PAY_US_EMP_TIME_IN_STATE_V is referenced by following:

SchemaAPPS
Package BodyPAY_US_ACTION_ARCH - show dependent code
SchemaPUBLIC
SynonymPAY_US_EMP_TIME_IN_STATE_V