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

VIEW: APPS.PAY_US_CITY_ACTION_INFO_V

Object Details
Object Name: PAY_US_CITY_ACTION_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_US_CITY_ACTION_INFO_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
Name Datatype Length Mandatory Comments
EFFECTIVE_DATE DATE

Effective date of the record
JURISDICTION_CODE VARCHAR2 (30)
Jurisdiction code
JURISDICTION_NAME VARCHAR2 (4000)
Jurisdiction name
ACTION_NUMBER NUMBER (15) Yes Foreign key to PAY_ACTION_CONTEXTS
ASSIGNMENT_ID NUMBER (10)
CITY_GROSS NUMBER

Gross amount
CITY_WITHHELD NUMBER

City tax withheld
CITY_SUBJ_WHABLE NUMBER

Subject to witholdable
CITY_SUBJ_NWABLE NUMBER

Subject to not Withholdable
CITY_PRE_TAX_REDNS NUMBER

Pre-Tax deductions
CITY_SUBJECT NUMBER

Amount subject to a given city tax
CITY_REDUCED_SUBJECT NUMBER

HEAD_TAX_LIABILITY NUMBER

Head tax amount due
HEAD_TAX_WITHHELD NUMBER

Head tax amount withheld
NON_RESIDENT_FLAG VARCHAR2 (240)
Resident or non resident flag
Query Text

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


SELECT EFFECTIVE_DATE
,      JURISDICTION_CODE
,      JURISDICTION_NAME
,      ACTION_NUMBER
,      ASSIGNMENT_ID
,      CITY_GROSS
,      CITY_WITHHELD
,      CITY_SUBJ_WHABLE
,      CITY_SUBJ_NWABLE
,      CITY_PRE_TAX_REDNS
,      CITY_SUBJECT
,      CITY_REDUCED_SUBJECT
,      HEAD_TAX_LIABILITY
,      HEAD_TAX_WITHHELD
,      NON_RESIDENT_FLAG
FROM APPS.PAY_US_CITY_ACTION_INFO_V;

Dependencies

[top of page]

APPS.PAY_US_CITY_ACTION_INFO_V references the following:

SchemaAPPS
SynonymPAY_ACTION_INFORMATION
PL/SQL PackagePAY_US_EMPLOYEE_PAYSLIP_WEB - show dependent code
APPS.PAY_US_CITY_ACTION_INFO_V is referenced by following:

SchemaAPPS
Package BodyPAY_ARCHIVER_REPORT_PKG - show dependent code