View: BEN_PER_CM

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

View Text

SELECT PCM.PER_CM_ID
, PCM.EFFECTIVE_START_DATE
, PCM.EFFECTIVE_END_DATE
, PCM.LF_EVT_OCRD_DT
, PCM.LER_ID
, PCM.PRTT_ENRT_ACTN_ID
, PCM.PERSON_ID
, PCM.BNF_PERSON_ID
, PCM.DPNT_PERSON_ID
, PCM.CM_TYP_ID
, PCM.RQSTBL_UNTL_DT
, PCM.BUSINESS_GROUP_ID
, PCM.PCM_ATTRIBUTE_CATEGORY
, PCM.PCM_ATTRIBUTE1
, PCM.PCM_ATTRIBUTE2
, PCM.PCM_ATTRIBUTE3
, PCM.PCM_ATTRIBUTE4
, PCM.PCM_ATTRIBUTE5
, PCM.PCM_ATTRIBUTE6
, PCM.PCM_ATTRIBUTE7
, PCM.PCM_ATTRIBUTE8
, PCM.PCM_ATTRIBUTE9
, PCM.PCM_ATTRIBUTE10
, PCM.PCM_ATTRIBUTE11
, PCM.PCM_ATTRIBUTE12
, PCM.PCM_ATTRIBUTE13
, PCM.PCM_ATTRIBUTE14
, PCM.PCM_ATTRIBUTE15
, PCM.PCM_ATTRIBUTE16
, PCM.PCM_ATTRIBUTE17
, PCM.PCM_ATTRIBUTE18
, PCM.PCM_ATTRIBUTE19
, PCM.PCM_ATTRIBUTE20
, PCM.PCM_ATTRIBUTE21
, PCM.PCM_ATTRIBUTE22
, PCM.PCM_ATTRIBUTE23
, PCM.PCM_ATTRIBUTE24
, PCM.PCM_ATTRIBUTE25
, PCM.PCM_ATTRIBUTE26
, PCM.PCM_ATTRIBUTE27
, PCM.PCM_ATTRIBUTE28
, PCM.PCM_ATTRIBUTE29
, PCM.PCM_ATTRIBUTE30
, PCM.LAST_UPDATE_DATE
, PCM.LAST_UPDATED_BY
, PCM.LAST_UPDATE_LOGIN
, PCM.CREATED_BY
, PCM.CREATION_DATE
, PCM.REQUEST_ID
, PCM.PROGRAM_APPLICATION_ID
, PCM.PROGRAM_ID
, PCM.PROGRAM_UPDATE_DATE
, PCM.OBJECT_VERSION_NUMBER
FROM BEN_PER_CM_F PCM
, BEN_PER_IN_LER PIL
WHERE PCM.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PCM.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PIL.PER_IN_LER_ID(+)=PCM.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID(+)=PCM.BUSINESS_GROUP_ID+0
AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL )

Columns