VIEW: APPS.BEN_PER_CM

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )