VIEW: APPS.BEN_VRBL_RT_RL_D

Source

View Text - Preformatted

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.USER_NAME 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' and vrr.effective_start_date between formula.effective_start_date (+) and formula.effective_end_date (+) and vrr.effective_start_date between acty_base_rt.effective_start_date (+) and acty_base_rt.effective_end_date (+)

View Text - HTML Formatted

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.USER_NAME
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'
AND VRR.EFFECTIVE_START_DATE BETWEEN FORMULA.EFFECTIVE_START_DATE (+)
AND FORMULA.EFFECTIVE_END_DATE (+)
AND VRR.EFFECTIVE_START_DATE BETWEEN ACTY_BASE_RT.EFFECTIVE_START_DATE (+)
AND ACTY_BASE_RT.EFFECTIVE_END_DATE (+)