[Home] [Help]
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
Name |
ROW_ID |
VRBL_RT_RL_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
DRVBL_FCTR_APLS_MEANING |
RT_TRTMT_MEANING |
ORDR_TO_APLY_NUM |
FORMULA_NAME |
ACTY_BASE_RT_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |