View: BEN_PER_CM_USG_D

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

View Text

SELECT PCU.ROWID ROW_ID
, PCU.PER_CM_USG_ID
, PCU.EFFECTIVE_START_DATE
, PCU.EFFECTIVE_END_DATE
, LER.NAME LER_NAME
, PGM.NAME PGM_NAME
, PL.NAME PL_NAME
, PL_TYP.NAME PL_TYP_NAME
, ACTN.NAME ACTN_NAME
, EP.STRT_DT
, EP.END_DT
, PCU.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
FROM BEN_PER_CM_USG_F PCU
, BEN_PER_CM_F PCM
, BEN_PER_IN_LER PIL
, FND_USER FUSER
, BEN_CM_TYP_USG_F CTU
, BEN_LER_F LER
, BEN_PGM_F PGM
, BEN_PL_F PL
, BEN_PL_TYP_F PL_TYP
, BEN_ACTN_TYP ACTN
, BEN_ENRT_PERD EP
WHERE FUSER.USER_ID (+)= PCU.LAST_UPDATED_BY
AND CTU.CM_TYP_USG_ID = PCU.CM_TYP_USG_ID
AND 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 = PL_TYP.PL_TYP_ID(+)
AND CTU.ACTN_TYP_ID = ACTN.ACTN_TYP_ID(+)
AND CTU.ENRT_PERD_ID = EP.ENRT_PERD_ID(+)
AND PCM.PER_CM_ID=PCU.PER_CM_ID
AND PCM.BUSINESS_GROUP_ID = PCU.BUSINESS_GROUP_ID
AND PIL.PER_IN_LER_ID(+)=PCM.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID(+)=PCM.BUSINESS_GROUP_ID
AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL )
AND PCU.EFFECTIVE_START_DATE BETWEEN CTU.EFFECTIVE_START_DATE
AND CTU.EFFECTIVE_END_DATE
AND PCU.EFFECTIVE_START_DATE BETWEEN NVL(LER.EFFECTIVE_START_DATE
, PCU.EFFECTIVE_START_DATE)
AND NVL(LER.EFFECTIVE_END_DATE
, PCU.EFFECTIVE_START_DATE)
AND PCU.EFFECTIVE_START_DATE BETWEEN NVL(PGM.EFFECTIVE_START_DATE
, PCU.EFFECTIVE_START_DATE)
AND NVL(PGM.EFFECTIVE_END_DATE
, PCU.EFFECTIVE_START_DATE)
AND PCU.EFFECTIVE_START_DATE BETWEEN NVL(PL.EFFECTIVE_START_DATE
, PCU.EFFECTIVE_START_DATE)
AND NVL(PL.EFFECTIVE_END_DATE
, PCU.EFFECTIVE_START_DATE)
AND PCU.EFFECTIVE_START_DATE BETWEEN PCM.EFFECTIVE_START_DATE
AND PCM.EFFECTIVE_END_DATE
AND PCU.EFFECTIVE_START_DATE BETWEEN NVL(PL_TYP.EFFECTIVE_START_DATE
, PCU.EFFECTIVE_START_DATE)
AND NVL(PL_TYP.EFFECTIVE_END_DATE
, PCU.EFFECTIVE_START_DATE)

Columns