[Home] [Help] [Dependency Information]
Object Name: | PAY_CA_FEDERAL_TAX_BAL_GRE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_CA_FEDERAL_TAX_BAL_GRE_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BALANCE_SET_NAME | VARCHAR2 | (30) | Yes | |
LEGISLATION_CODE | VARCHAR2 | (30) | ||
TAX_BALANCE_NAME | VARCHAR2 | (240) | ||
WAGE_BALANCE_NAME | VARCHAR2 | (240) | ||
DIMENSION | VARCHAR2 | (240) | ||
REPORTING_NAME | VARCHAR2 | (240) | ||
FORMAT_CODE | VARCHAR2 | (240) | ||
TAX_UNIT_ID | NUMBER | (15) | Yes | |
GRE_NAME | VARCHAR2 | (240) | Yes | |
TAX_GROUP_ID | VARCHAR2 | (150) | ||
TAX_GROUP_NAME | VARCHAR2 | (240) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
BUSINESS_NO | VARCHAR2 | (150) | ||
SESSION_ID | NUMBER | |||
EFFECTIVE_DATE | DATE | |||
TAX_CTD_VALUE | NUMBER | |||
WAGE_CTD_VALUE | NUMBER | |||
TAX_OTD_VALUE | NUMBER | |||
WAGE_OTD_VALUE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BALANCE_SET_NAME
, LEGISLATION_CODE
, TAX_BALANCE_NAME
, WAGE_BALANCE_NAME
, DIMENSION
, REPORTING_NAME
, FORMAT_CODE
, TAX_UNIT_ID
, GRE_NAME
, TAX_GROUP_ID
, TAX_GROUP_NAME
, BUSINESS_GROUP_ID
, BUSINESS_NO
, SESSION_ID
, EFFECTIVE_DATE
, TAX_CTD_VALUE
, WAGE_CTD_VALUE
, TAX_OTD_VALUE
, WAGE_OTD_VALUE
FROM APPS.PAY_CA_FEDERAL_TAX_BAL_GRE_V;
APPS.PAY_CA_FEDERAL_TAX_BAL_GRE_V is not referenced by any database object
|
|
|