View: BEN_ACTL_PREM_D

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

View Text

SELECT APR.ACTL_PREM_ID
, APR.EFFECTIVE_START_DATE
, APR.EFFECTIVE_END_DATE
, APR.NAME
, ACTY_REF.MEANING
, UOM.NAME
, APR.CR_LKBK_CRNT_PY_ONLY_FLAG
, APR.LAST_UPDATE_DATE
, FUSER.USER_NAME
, APR.CREATION_DATE
, PRTL_MTH.MEANING
, PRTL_MTH2.FORMULA_NAME
, APR.WSH_RL_DY_MO_NUM
, RT_TYP.MEANING
, APR.VAL
, CALC_MTHD.MEANING
, PRDCT.MEANING
, RNDG.MEANING
, RNDG2.FORMULA_NAME
, VAL_CALC.FORMULA_NAME
, ASNMT.MEANING
, ASNMT_LVL.MEANING
, ACTL_PREM.MEANING
, PREM_PYR.MEANING
, APR.CR_LKBK_VAL
, PRSPCTV_R_RTSPCTV.MEANING
, APR.UPR_LMT_VAL
, UPR_LMT.FORMULA_NAME
, APR.LWR_LMT_VAL
, LWR_LMT.FORMULA_NAME
, OPT.NAME
, PLN.NAME
FROM BEN_ACTL_PREM_F APR
, FND_USER_VIEW FUSER
, BEN_PL_F PLN
, BEN_OIPL_F OIPL
, BEN_OPT_F OPT
, HR_LOOKUPS PRTL_MTH
, HR_LOOKUPS ACTL_PREM
, HR_LOOKUPS ASNMT
, HR_LOOKUPS ASNMT_LVL
, HR_LOOKUPS PREM_PYR
, HR_LOOKUPS PRSPCTV_R_RTSPCTV
, HR_LOOKUPS PRDCT
, HR_LOOKUPS ACTY_REF
, HR_LOOKUPS RNDG
, HR_LOOKUPS CALC_MTHD
, HR_LOOKUPS RT_TYP
, FF_FORMULAS_F PRTL_MTH2
, FF_FORMULAS_F RNDG2
, FF_FORMULAS_F UPR_LMT
, FF_FORMULAS_F LWR_LMT
, FF_FORMULAS_F VAL_CALC
, FND_CURRENCIES_VL UOM
WHERE FUSER.USER_ID(+) = APR.LAST_UPDATED_BY
AND PLN.PL_ID(+) = APR.PL_ID
AND OIPL.OIPL_ID(+) = APR.OIPL_ID
AND OPT.OPT_ID = OIPL.OPT_ID
AND PRTL_MTH.LOOKUP_TYPE(+) = 'BEN_PRTL_MO_DET_MTHD'
AND PRTL_MTH.LOOKUP_CODE(+) = APR.PRTL_MO_DET_MTHD_CD
AND ACTL_PREM.LOOKUP_TYPE(+) = 'BEN_PREM_TYP'
AND ACTL_PREM.LOOKUP_CODE(+) = APR.ACTL_PREM_TYP_CD
AND ASNMT.LOOKUP_TYPE(+) = 'BEN_PREM_ASNMT'
AND ASNMT.LOOKUP_CODE(+) = APR.PREM_ASNMT_CD
AND ASNMT_LVL.LOOKUP_TYPE(+)= 'BEN_PREM_ASNMT_LVL'
AND ASNMT_LVL.LOOKUP_CODE(+) = APR.PREM_ASNMT_LVL_CD
AND PREM_PYR.LOOKUP_TYPE(+) = 'BEN_PREM_PYR'
AND PREM_PYR.LOOKUP_CODE(+) = APR.PREM_PYR_CD
AND PRSPCTV_R_RTSPCTV.LOOKUP_TYPE(+) = 'BEN_PRSPCTV_R_RTSPCTV'
AND PRSPCTV_R_RTSPCTV.LOOKUP_CODE(+) = APR.PRSPTV_R_RTSPTV_CD
AND PRDCT.LOOKUP_TYPE(+) = 'BEN_PRDCT'
AND PRDCT.LOOKUP_CODE(+) = APR.PRDCT_CD
AND ACTY_REF.LOOKUP_TYPE(+) = 'BEN_ACTY_REF_PERD'
AND ACTY_REF.LOOKUP_CODE(+) = APR.ACTY_REF_PERD_CD
AND RNDG.LOOKUP_TYPE(+) = 'BEN_RNDG'
AND RNDG.LOOKUP_CODE(+) = APR.RNDG_CD
AND CALC_MTHD.LOOKUP_TYPE(+) = 'BEN_ACTL_PREM_MLT'
AND CALC_MTHD.LOOKUP_CODE(+) = APR.MLT_CD
AND RT_TYP.LOOKUP_TYPE(+) = 'BEN_BNFT_RT_TYP'
AND RT_TYP.LOOKUP_CODE(+) = APR.BNFT_RT_TYP_CD
AND PRTL_MTH2.FORMULA_ID(+) = APR.PRTL_MO_DET_MTHD_RL
AND RNDG2.FORMULA_ID(+) = APR.RNDG_RL
AND UPR_LMT.FORMULA_ID(+) = APR.UPR_LMT_CALC_RL
AND LWR_LMT.FORMULA_ID(+) = APR.LWR_LMT_CALC_RL
AND VAL_CALC.FORMULA_ID(+) = APR.VAL_CALC_RL
AND UOM.CURRENCY_CODE(+) = APR.UOM
AND APR.EFFECTIVE_START_DATE BETWEEN PLN.EFFECTIVE_START_DATE(+)
AND PLN.EFFECTIVE_END_DATE(+)
AND APR.EFFECTIVE_START_DATE BETWEEN OIPL.EFFECTIVE_START_DATE(+)
AND OIPL.EFFECTIVE_END_DATE(+)
AND OIPL.EFFECTIVE_START_DATE BETWEEN OPT.EFFECTIVE_START_DATE(+)
AND OPT.EFFECTIVE_END_DATE(+)

Columns