View: BENBV_VRBL_RT_RL_V

Product:	BEN - Advanced Benefits
Description:	This view identifies a rule that may be used to calculate an additional amount to adjust the values determined by an activity base rate.
Implementation/DBA Data:	APPS.BENBV_VRBL_RT_RL_V

View Text

SELECT VRR.EFFECTIVE_START_DATE
, VRR.EFFECTIVE_END_DATE
, VRR.ORDR_TO_APLY_NUM
, /* DESCRIPTIVE FLEXFIELD */ '_DF:BEN:BEN_VRBL_RT_RL_F:VRR'
, /* CODES */ VRR.RT_TRTMT_CD
, HR_BIS.BIS_DECODE_LOOKUP('BEN_RT_TRTMT'
, VRR.RT_TRTMT_CD)
, VRR.DRVBL_FCTR_APLS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, VRR.DRVBL_FCTR_APLS_FLAG)
, /* ID COLUMNS */ VRR.VRBL_RT_RL_ID
, VRR.BUSINESS_GROUP_ID
, VRR.FORMULA_ID
, VRR.ACTY_BASE_RT_ID
, /* WHO COLUMNS */ VRR.LAST_UPDATE_DATE
, VRR.LAST_UPDATED_BY
, VRR.CREATED_BY
, VRR.CREATION_DATE
FROM BEN_VRBL_RT_RL_F VRR
WHERE VRR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, VRR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns