VIEW: APPS.BENBV_VRBL_RT_RL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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