FND Design Data [Home] [Help]

View: BEN_PRTT_VSTG_D

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

SELECT PVS.ROWID ROW_ID
, PVS.PRTT_VSTG_ID
, PVS.EFFECTIVE_START_DATE
, PVS.EFFECTIVE_END_DATE
, PVS.PCT_VSTD_VAL
, PVS.AGE_MOS_NUM
, PVS.AGE_YRS_NUM
, PVS.LGTH_OF_SVC_YRS_NUM
, PVS.AGE_DET_AS_OF_DT
, PVS.LGTH_OF_SVC_MOS_NUM
, PVS.LGTH_OF_SVC_DET_AS_OF_DT
, PVS.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_PRTT_VSTG_F PVS
, FND_USER FUSER
WHERE FUSER.USER_ID (+)= PVS .LAST_UPDATED_BY

Columns

Name
ROW_ID
PRTT_VSTG_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
PCT_VSTD_VAL
AGE_MOS_NUM
AGE_YRS_NUM
LGTH_OF_SVC_YRS_NUM
AGE_DET_AS_OF_DT
LGTH_OF_SVC_MOS_NUM
LGTH_OF_SVC_DET_AS_OF_DT
LAST_UPDATE_DATE
LAST_UPDATED_BY