FND Design Data [Home] [Help]

View: BEN_VRBL_RT_PRFL_RL_D

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

SELECT VPR.VRBL_RT_PRFL_RL_ID
, VPR.EFFECTIVE_START_DATE
, VPR.EFFECTIVE_END_DATE
, VAPRO.NAME
, FFF.FORMULA_NAME
, VPR.ORDR_TO_APLY_NUM
, VPR.DRVBL_FCTR_APLS_FLAG
, VPR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_VRBL_RT_PRFL_RL_F VPR
, FND_USER FUSER
, FF_FORMULAS_F FFF
, BEN_VRBL_RT_PRFL_F VAPRO
WHERE FUSER.USER_ID (+) = VPR.LAST_UPDATED_BY
AND VPR.FORMULA_ID = FFF.FORMULA_ID
AND VPR.VRBL_RT_PRFL_ID = VAPRO.VRBL_RT_PRFL_ID

Columns

Name
VRBL_RT_PRFL_RL_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
VRBL_RT_PRFL_NAME
FORMULA_NAME
ORDR_NUM
DRVBL_FCTR_APLS_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY