[Home] [Help]
[Dependency Information]
| Object Name: | PAY_US_CITY_TAX_BAL_GRE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PAY.PAY_US_CITY_TAX_BAL_GRE_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BALANCE_SET_NAME | VARCHAR2 | (30) | Yes | |
| LEGISLATION_CODE | VARCHAR2 | (30) | ||
| BALANCE_NAME | VARCHAR2 | (240) | ||
| TAX_CLASSIFICATION | VARCHAR2 | (240) | ||
| WAGES_CLASSIFICATION | VARCHAR2 | (240) | ||
| DIMENSION | VARCHAR2 | (240) | ||
| REPORTING_NAME | VARCHAR2 | (240) | ||
| STATE_ABBREV | VARCHAR2 | (2) | Yes | |
| STATE_CODE | VARCHAR2 | (2) | Yes | |
| CITY_NAME | VARCHAR2 | (30) | Yes | |
| CITY_JD | VARCHAR2 | (11) | ||
| GRE_ID | NUMBER | (15) | ||
| CTD_TAX_VALUE | NUMBER | |||
| CTD_WAGE_VALUE | NUMBER | |||
| OTD_TAX_VALUE | NUMBER | |||
| OTD_WAGE_VALUE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BALANCE_SET_NAME
, LEGISLATION_CODE
, BALANCE_NAME
, TAX_CLASSIFICATION
, WAGES_CLASSIFICATION
, DIMENSION
, REPORTING_NAME
, STATE_ABBREV
, STATE_CODE
, CITY_NAME
, CITY_JD
, GRE_ID
, CTD_TAX_VALUE
, CTD_WAGE_VALUE
, OTD_TAX_VALUE
, OTD_WAGE_VALUE
FROM APPS.PAY_US_CITY_TAX_BAL_GRE_V;
APPS
PAY_BALANCE_SETS
PAY_US_CITY_NAMES
PAY_US_PAYROLL_UTILS
- show dependent code
PAY_US_STATES
PAY_US_TAX_BALS_PKG
- show dependent code
PAY_US_TAX_UNIT_CITIES_V
APPS.PAY_US_CITY_TAX_BAL_GRE_V is not referenced by any database object
|
|
|
|