View: BEN_PREM_CSTG_BY_SGMT_D

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

View Text

SELECT CBS.ROWID ROW_ID
, CBS.PREM_CSTG_BY_SGMT_ID
, CBS.EFFECTIVE_START_DATE
, CBS.EFFECTIVE_END_DATE
, CBS.SGMT_NUM
, HL1.MEANING
, FF1.FORMULA_NAME
, ACTL_PREM.NAME
, CBS.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PREM_CSTG_BY_SGMT_F CBS
, FND_USER_VIEW FUSER
, BEN_ACTL_PREM_F ACTL_PREM
, HR_LOOKUPS HL1
, FF_FORMULAS_F FF1
WHERE FUSER.USER_ID (+)= CBS .LAST_UPDATED_BY
AND ACTL_PREM.ACTL_PREM_ID (+)= CBS .ACTL_PREM_ID
AND HL1.LOOKUP_CODE (+)= CBS .SGMT_CSTG_MTHD_CD
AND HL1.LOOKUP_TYPE (+)= 'BEN_SGMT_CSTG_MTHD'
AND FF1.FORMULA_ID (+)= CBS .SGMT_CSTG_MTHD_RL
AND CBS .EFFECTIVE_START_DATE BETWEEN FF1.EFFECTIVE_START_DATE
AND FF1.EFFECTIVE_END_DATE

Columns