FND Design Data [Home] [Help]

View: BEN_ELIG_QUA_IN_GR_PRTE_D

Product: BEN - Advanced Benefits
Description:
Implementation/DBA Data: ViewAPPS.BEN_ELIG_QUA_IN_GR_PRTE_D
View Text

SELECT EQG.ELIG_QUA_IN_GR_PRTE_ID
, EQG.EFFECTIVE_START_DATE
, EQG.EFFECTIVE_END_DATE
, HR1.MEANING
, EQG.EXCLD_FLAG
, EQG.BUSINESS_GROUP_ID
, EQG.ELIGY_PRFL_ID
, EQG.OBJECT_VERSION_NUMBER
, EQG.ORDR_NUM
, EQG.LAST_UPDATE_DATE
, EQG.LAST_UPDATED_BY
, EQG.LAST_UPDATE_LOGIN
, EQG.CREATED_BY
, EQG.CREATION_DATE
FROM BEN_ELIG_QUA_IN_GR_PRTE_F EQG
, FND_USER_VIEW FUSER
, HR_LOOKUPS HR1
WHERE FUSER.USER_ID(+) = EQG.LAST_UPDATED_BY
AND HR1.LOOKUP_CODE = 'BEN_CWB_QUAR_IN_GRD'

Columns

Name
ELIG_QUA_IN_GR_PRTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
QUAR_IN_GRADE
EXCLD_FLAG
BUSINESS_GROUP_ID
ELIGY_PRFL_ID
OBJECT_VERSION_NUMBER
ORDR_NUM
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE