View: BEN_TTL_CVG_VOL_RT_D

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

View Text

SELECT TCV.ROWID ROW_ID
, TCV.TTL_CVG_VOL_RT_ID
, TCV.EFFECTIVE_START_DATE
, TCV.EFFECTIVE_END_DATE
, HL1.MEANING
, HL2.MEANING
, HL3.MEANING
, TCV.ORDR_NUM
, TCV.MN_CVG_VOL_AMT
, TCV.MX_CVG_VOL_AMT
, HL4.MEANING
, FF1.FORMULA_NAME
, VRBL_RT_PRFL.NAME
, TCV.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_TTL_CVG_VOL_RT_F TCV
, FND_USER_VIEW FUSER
, BEN_VRBL_RT_PRFL_F VRBL_RT_PRFL
, HR_LOOKUPS HL1
, HR_LOOKUPS HL2
, HR_LOOKUPS HL3
, HR_LOOKUPS HL4
, FF_FORMULAS_F FF1
WHERE FUSER.USER_ID (+)= TCV.LAST_UPDATED_BY
AND VRBL_RT_PRFL.VRBL_RT_PRFL_ID (+)= TCV.VRBL_RT_PRFL_ID
AND HL4.LOOKUP_CODE (+)= TCV.CVG_VOL_DET_CD
AND HL4.LOOKUP_TYPE (+)= 'BEN_CVG_DET_DT'
AND HL1.LOOKUP_CODE (+)= TCV.EXCLD_FLAG
AND HL1.LOOKUP_TYPE (+)= 'YES_NO'
AND HL2.LOOKUP_CODE (+)= TCV.NO_MN_CVG_VOL_AMT_APLS_FLAG
AND HL2.LOOKUP_TYPE (+)= 'YES_NO'
AND HL3.LOOKUP_CODE (+)= TCV.NO_MX_CVG_VOL_AMT_APLS_FLAG
AND HL3.LOOKUP_TYPE (+)= 'YES_NO'
AND FF1.FORMULA_ID (+)= TCV.CVG_VOL_DET_RL
AND TCV.EFFECTIVE_START_DATE BETWEEN FF1.EFFECTIVE_START_DATE(+)
AND FF1.EFFECTIVE_END_DATE(+)

Columns