Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
SELECT B.ROWID ROW_ID
, B.GLOBAL_ID
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.BUSINESS_GROUP_ID
, B.LEGISLATION_CODE
, B.DATA_TYPE
, B.GLOBAL_VALUE
, B.GLOBAL_NAME BASE_GLOBAL_NAME
, B.GLOBAL_DESCRIPTION BASE_GLOBAL_DESCRIPTION
, TL.GLOBAL_NAME
, TL.GLOBAL_DESCRIPTION
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.OBJECT_VERSION_NUMBER
FROM FF_GLOBALS_F B
, FF_GLOBALS_F_TL TL
WHERE B.GLOBAL_ID=TL.GLOBAL_ID
AND TL.LANGUAGE=USERENV('LANG')