VIEW: APPS.BEN_VRBL_RT_PRFL_RL_D

Source

View Text - Preformatted

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 AND vpr.effective_start_date between vapro.effective_start_date(+) and vapro.effective_end_date(+)

View Text - HTML Formatted

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
AND VPR.EFFECTIVE_START_DATE BETWEEN VAPRO.EFFECTIVE_START_DATE(+)
AND VAPRO.EFFECTIVE_END_DATE(+)