View: BEN_PER_CM_TRGR_D

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

View Text

SELECT PCR.ROWID ROW_ID
, PCR.PER_CM_TRGR_ID
, PCR.EFFECTIVE_START_DATE
, PCR.EFFECTIVE_END_DATE
, CM_TRGR.DESC_TXT CM_TRGR_NAME
, PCR.LAST_UPDATE_DATE
, FUSER.USER_NAME LAST_UPDATED_BY
FROM BEN_PER_CM_TRGR_F PCR
, BEN_PER_CM_F PCM
, BEN_PER_IN_LER PIL
, FND_USER_VIEW FUSER
, BEN_CM_TRGR CM_TRGR
WHERE FUSER.USER_ID (+)= PCR.LAST_UPDATED_BY
AND CM_TRGR.CM_TRGR_ID (+)= PCR.CM_TRGR_ID
AND PCM.PER_CM_ID=PCR.PER_CM_ID
AND PCM.BUSINESS_GROUP_ID=PCR.BUSINESS_GROUP_ID
AND PCR.EFFECTIVE_START_DATE BETWEEN PCM.EFFECTIVE_START_DATE
AND PCM.EFFECTIVE_END_DATE
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 )

Columns