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

VIEW: HR.PAY_BALANCE_DIMENSIONS#

Object Details
Object Name: PAY_BALANCE_DIMENSIONS#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BALANCE_DIMENSION_ID NUMBER (9) Yes
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
ROUTE_ID NUMBER (15) Yes
DATABASE_ITEM_SUFFIX VARCHAR2 (80) Yes
DIMENSION_NAME VARCHAR2 (80) Yes
DIMENSION_TYPE VARCHAR2 (1) Yes
DESCRIPTION VARCHAR2 (240)
FEED_CHECKING_CODE VARCHAR2 (61)
LEGISLATION_SUBGROUP VARCHAR2 (30)
PAYMENTS_FLAG VARCHAR2 (30)
EXPIRY_CHECKING_CODE VARCHAR2 (61)
EXPIRY_CHECKING_LEVEL VARCHAR2 (1)
FEED_CHECKING_TYPE VARCHAR2 (1)
DIMENSION_LEVEL VARCHAR2 (30)
PERIOD_TYPE VARCHAR2 (30)
ASG_ACTION_BALANCE_DIM_ID NUMBER (9)
DATABASE_ITEM_FUNCTION VARCHAR2 (256)
SAVE_RUN_BALANCE_ENABLED VARCHAR2 (30)
START_DATE_CODE VARCHAR2 (61)
APPLICATION_ID NUMBER (9)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT BALANCE_DIMENSION_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      ROUTE_ID
,      DATABASE_ITEM_SUFFIX
,      DIMENSION_NAME
,      DIMENSION_TYPE
,      DESCRIPTION
,      FEED_CHECKING_CODE
,      LEGISLATION_SUBGROUP
,      PAYMENTS_FLAG
,      EXPIRY_CHECKING_CODE
,      EXPIRY_CHECKING_LEVEL
,      FEED_CHECKING_TYPE
,      DIMENSION_LEVEL
,      PERIOD_TYPE
,      ASG_ACTION_BALANCE_DIM_ID
,      DATABASE_ITEM_FUNCTION
,      SAVE_RUN_BALANCE_ENABLED
,      START_DATE_CODE
,      APPLICATION_ID
,      ZD_EDITION_NAME
FROM HR.PAY_BALANCE_DIMENSIONS#;

Dependencies

[top of page]

HR.PAY_BALANCE_DIMENSIONS# references the following:

SchemaHR
TablePAY_BALANCE_DIMENSIONS
HR.PAY_BALANCE_DIMENSIONS# is referenced by following:

SchemaAPPS
SynonymPAY_BALANCE_DIMENSIONS
TriggerPAY_BALANCE_DIMENSIONS+
TriggerPAY_PBD_MNT_TL_ARD
TriggerPAY_PBD_MNT_TL_ARI
TriggerPAY_PBD_MNT_TL_ARU