VIEW: APPS.BEN_PREM_CSTG_BY_SGMT_D

Source

View Text - Preformatted

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(+) AND cbs.effective_start_date BETWEEN actl_prem.effective_start_date(+) AND actl_prem.effective_end_date(+)

View Text - HTML Formatted

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(+)
AND CBS.EFFECTIVE_START_DATE BETWEEN ACTL_PREM.EFFECTIVE_START_DATE(+)
AND ACTL_PREM.EFFECTIVE_END_DATE(+)