Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_BALANCE_DIMENSIONS_VL |
SELECT B.ROWID ROW_ID
, B.BALANCE_DIMENSION_ID
, B.BUSINESS_GROUP_ID
, B.LEGISLATION_CODE
, B.ROUTE_ID
, B.DIMENSION_TYPE
, TL.DATABASE_ITEM_SUFFIX
, TL.DIMENSION_NAME
, TL.DESCRIPTION
, B.FEED_CHECKING_CODE
, B.LEGISLATION_SUBGROUP
, B.PAYMENTS_FLAG
, B.EXPIRY_CHECKING_CODE
, B.EXPIRY_CHECKING_LEVEL
, B.FEED_CHECKING_TYPE
, B.DIMENSION_LEVEL
, B.PERIOD_TYPE
, B.ASG_ACTION_BALANCE_DIM_ID
, B.DATABASE_ITEM_FUNCTION
, B.SAVE_RUN_BALANCE_ENABLED
, B.START_DATE_CODE
FROM PAY_BALANCE_DIMENSIONS B
, PAY_BALANCE_DIMENSIONS_TL TL
WHERE B.BALANCE_DIMENSION_ID = TL.BALANCE_DIMENSION_ID
AND TL.LANGUAGE=USERENV('LANG')