View: BEN_VRBL_RT_RL_D

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_VRBL_RT_RL_D

View Text

SELECT VRR.ROWID ROW_ID
, VRR.VRBL_RT_RL_ID
, VRR.EFFECTIVE_START_DATE
, VRR.EFFECTIVE_END_DATE
, DRVBL_FCTR_APLS.MEANING
, RT_TRTMT.MEANING
, VRR.ORDR_TO_APLY_NUM
, FORMULA_NAME
, ACTY_BASE_RT.NAME
, VRR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_VRBL_RT_RL_F VRR
, FND_USER FUSER
, FF_FORMULAS_F FORMULA
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, HR_LOOKUPS RT_TRTMT
, HR_LOOKUPS DRVBL_FCTR_APLS
WHERE FUSER.USER_ID (+)= VRR .LAST_UPDATED_BY
AND FORMULA.FORMULA_ID (+)= VRR .FORMULA_ID
AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= VRR .ACTY_BASE_RT_ID
AND RT_TRTMT.LOOKUP_CODE (+)= VRR .RT_TRTMT_CD
AND RT_TRTMT.LOOKUP_TYPE (+)= 'BEN_RT_TRTMT'
AND DRVBL_FCTR_APLS.LOOKUP_CODE (+)= VRR .DRVBL_FCTR_APLS_FLAG
AND DRVBL_FCTR_APLS.LOOKUP_TYPE (+)= 'YES_NO'

Columns