View: BEN_PER_CM_PCU_LOV_V

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

View Text

SELECT LER.NAME LER_NAME
, PGM.NAME PGM_NAME
, PL.NAME PL_NAME
, PLT.NAME PT_NAME
, ACTN.NAME ACTN_NAME
, FF.FORMULA_NAME RL_NAME
, EP.STRT_DT
, EP.END_DT
, CTU.CM_TYP_USG_ID
, CTU.CM_TYP_ID
, CTU.BUSINESS_GROUP_ID
FROM BEN_LER_V LER
, BEN_PGM_F PGM
, BEN_PL_F PL
, BEN_PL_TYP_F PLT
, BEN_ACTN_TYP ACTN
, FF_FORMULAS_F FF
, BEN_ENRT_PERD EP
, BEN_CM_TYP_USG_F CTU
, FND_SESSIONS FND
WHERE CTU.LER_ID = LER.LER_ID(+)
AND CTU.PGM_ID = PGM.PGM_ID(+)
AND CTU.PL_ID = PL.PL_ID(+)
AND CTU.PL_TYP_ID = PLT.PL_TYP_ID(+)
AND CTU.ACTN_TYP_ID = ACTN.ACTN_TYP_ID(+)
AND CTU.CM_USG_RL = FF.FORMULA_ID(+)
AND CTU.ENRT_PERD_ID = EP.ENRT_PERD_ID(+)
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN NVL(LER.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE)
AND NVL(LER.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE)
AND FND.EFFECTIVE_DATE BETWEEN NVL(PGM.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE)
AND NVL(PGM.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE)
AND FND.EFFECTIVE_DATE BETWEEN NVL(PL.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE)
AND NVL(PL.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE)
AND FND.EFFECTIVE_DATE BETWEEN NVL(PLT.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE)
AND NVL(PLT.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE)
AND FND.EFFECTIVE_DATE BETWEEN NVL(FF.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE)
AND NVL(FF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE)
AND FND.EFFECTIVE_DATE BETWEEN NVL(CTU.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE)
AND NVL(CTU.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE)

Columns