Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_QUA_IN_GR_RT_D |
SELECT QIG.QUA_IN_GR_RT_ID
, QIG.EFFECTIVE_START_DATE
, QIG.EFFECTIVE_END_DATE
, HR1.MEANING
, QIG.EXCLD_FLAG
, QIG.BUSINESS_GROUP_ID
, QIG.VRBL_RT_PRFL_ID
, QIG.OBJECT_VERSION_NUMBER
, QIG.ORDR_NUM
, QIG.LAST_UPDATE_DATE
, QIG.LAST_UPDATED_BY
, QIG.LAST_UPDATE_LOGIN
, QIG.CREATED_BY
, QIG.CREATION_DATE
FROM BEN_QUA_IN_GR_RT_F QIG
, FND_USER_VIEW FUSER
, HR_LOOKUPS HR1
WHERE FUSER.USER_ID(+) = QIG.LAST_UPDATED_BY
AND HR1.LOOKUP_TYPE = 'BEN_CWB_QUAR_IN_GRD'
AND HR1.LOOKUP_CODE = QIG.QUAR_IN_GRADE_CD