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


VIEW: APPS.PAY_CA_WCB_GRP_LEVEL_V

Object Details
Object Name: PAY_CA_WCB_GRP_LEVEL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_CA_WCB_GRP_LEVEL_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
ACCOUNT_NUMBER VARCHAR2 (30) Yes
PROVINCE VARCHAR2 (150)
SOURCE_ID NUMBER (9) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
CODE VARCHAR2 (30) Yes
RATE NUMBER (10)
DESCRIPTION VARCHAR2 (80)
BALANCE_SET_NAME VARCHAR2 (30) Yes
BASE_BAL_NAME_TAXABLE VARCHAR2 (240)
BASE_BAL_NAME_LIABILITY VARCHAR2 (240)
BASE_BAL_NAME_EXCESS VARCHAR2 (240)
TL_BAL_NAME_TAXABLE VARCHAR2 (80) Yes
TL_BAL_NAME_LIABILITY VARCHAR2 (80) Yes
TL_BAL_NAME_EXCESS VARCHAR2 (80) Yes
DIMENSION VARCHAR2 (240)
LEGISLATION_CODE VARCHAR2 (30)
EFFECTIVE_DATE DATE

PYDATE_TAXABLE NUMBER

PYDATE_LIABILITY NUMBER

PYDATE_EXCESS NUMBER

OTD_TAXABLE NUMBER

OTD_LIABILITY NUMBER

OTD_EXCESS NUMBER

Query Text

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


SELECT ACCOUNT_NUMBER
,      PROVINCE
,      SOURCE_ID
,      BUSINESS_GROUP_ID
,      CODE
,      RATE
,      DESCRIPTION
,      BALANCE_SET_NAME
,      BASE_BAL_NAME_TAXABLE
,      BASE_BAL_NAME_LIABILITY
,      BASE_BAL_NAME_EXCESS
,      TL_BAL_NAME_TAXABLE
,      TL_BAL_NAME_LIABILITY
,      TL_BAL_NAME_EXCESS
,      DIMENSION
,      LEGISLATION_CODE
,      EFFECTIVE_DATE
,      PYDATE_TAXABLE
,      PYDATE_LIABILITY
,      PYDATE_EXCESS
,      OTD_TAXABLE
,      OTD_LIABILITY
,      OTD_EXCESS
FROM APPS.PAY_CA_WCB_GRP_LEVEL_V;

Dependencies

[top of page]

APPS.PAY_CA_WCB_GRP_LEVEL_V references the following:

SchemaAPPS
SynonymFF_CONTEXTS
SynonymFND_SESSIONS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ACTION_CONTEXTS
SynonymPAY_BALANCE_SETS
SynonymPAY_BALANCE_TYPES
SynonymPAY_BALANCE_TYPES_TL
PL/SQL PackagePAY_CA_GROUP_LEVEL_BAL_PKG - show dependent code
ViewPAY_WCI_ACCOUNTS_V
SynonymPAY_WCI_RATES

APPS.PAY_CA_WCB_GRP_LEVEL_V is not referenced by any database object