VIEW: APPS.BEN_PER_CM_PCU_LOV_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)