Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FF_GLOBALS_F_FV |
SELECT B.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.BASE_GLOBAL_NAME
, B.BASE_GLOBAL_DESCRIPTION
, B.GLOBAL_NAME
, B.GLOBAL_DESCRIPTION
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, HLU.MEANING DATA_TYPE_MEANING
, B.OBJECT_VERSION_NUMBER
FROM FF_GLOBALS_F_VL B
, HR_LOOKUPS HLU
, FND_SESSIONS SES
WHERE HLU.LOOKUP_TYPE = 'DATA_TYPE'
AND HLU.LOOKUP_CODE = B.DATA_TYPE
AND SES.SESSION_ID=USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE
AND B.EFFECTIVE_END_DATE