Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PER_CM_X |
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 TRUNC(SYSDATE) 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+0
AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL )