[Home] [Help]
View: 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 |