VIEW: APPS.BEN_PER_CM_TRGR

Source

View Text - Preformatted

SELECT pcr.PER_CM_TRGR_ID ,pcr.EFFECTIVE_START_DATE ,pcr.EFFECTIVE_END_DATE ,pcr.CM_TRGR_ID ,pcr.PER_CM_ID ,pcr.BUSINESS_GROUP_ID ,pcr.PCR_ATTRIBUTE_CATEGORY ,pcr.PCR_ATTRIBUTE1 ,pcr.PCR_ATTRIBUTE2 ,pcr.PCR_ATTRIBUTE3 ,pcr.PCR_ATTRIBUTE4 ,pcr.PCR_ATTRIBUTE5 ,pcr.PCR_ATTRIBUTE6 ,pcr.PCR_ATTRIBUTE7 ,pcr.PCR_ATTRIBUTE8 ,pcr.PCR_ATTRIBUTE9 ,pcr.PCR_ATTRIBUTE10 ,pcr.PCR_ATTRIBUTE11 ,pcr.PCR_ATTRIBUTE12 ,pcr.PCR_ATTRIBUTE13 ,pcr.PCR_ATTRIBUTE14 ,pcr.PCR_ATTRIBUTE15 ,pcr.PCR_ATTRIBUTE16 ,pcr.PCR_ATTRIBUTE17 ,pcr.PCR_ATTRIBUTE18 ,pcr.PCR_ATTRIBUTE19 ,pcr.PCR_ATTRIBUTE20 ,pcr.PCR_ATTRIBUTE21 ,pcr.PCR_ATTRIBUTE22 ,pcr.PCR_ATTRIBUTE23 ,pcr.PCR_ATTRIBUTE24 ,pcr.PCR_ATTRIBUTE25 ,pcr.PCR_ATTRIBUTE26 ,pcr.PCR_ATTRIBUTE27 ,pcr.PCR_ATTRIBUTE28 ,pcr.PCR_ATTRIBUTE29 ,pcr.PCR_ATTRIBUTE30 ,pcr.LAST_UPDATE_DATE ,pcr.LAST_UPDATED_BY ,pcr.LAST_UPDATE_LOGIN ,pcr.CREATED_BY ,pcr.CREATION_DATE ,pcr.REQUEST_ID ,pcr.PROGRAM_APPLICATION_ID ,pcr.PROGRAM_ID ,pcr.PROGRAM_UPDATE_DATE ,pcr.OBJECT_VERSION_NUMBER from BEN_PER_CM_TRGR_F pcr , ben_per_cm_f pcm , ben_per_in_ler pil WHERE pcr.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and pcr.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and pcm.per_cm_id=pcr.per_cm_id and pcm.business_group_id+0=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+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 PCR.PER_CM_TRGR_ID
, PCR.EFFECTIVE_START_DATE
, PCR.EFFECTIVE_END_DATE
, PCR.CM_TRGR_ID
, PCR.PER_CM_ID
, PCR.BUSINESS_GROUP_ID
, PCR.PCR_ATTRIBUTE_CATEGORY
, PCR.PCR_ATTRIBUTE1
, PCR.PCR_ATTRIBUTE2
, PCR.PCR_ATTRIBUTE3
, PCR.PCR_ATTRIBUTE4
, PCR.PCR_ATTRIBUTE5
, PCR.PCR_ATTRIBUTE6
, PCR.PCR_ATTRIBUTE7
, PCR.PCR_ATTRIBUTE8
, PCR.PCR_ATTRIBUTE9
, PCR.PCR_ATTRIBUTE10
, PCR.PCR_ATTRIBUTE11
, PCR.PCR_ATTRIBUTE12
, PCR.PCR_ATTRIBUTE13
, PCR.PCR_ATTRIBUTE14
, PCR.PCR_ATTRIBUTE15
, PCR.PCR_ATTRIBUTE16
, PCR.PCR_ATTRIBUTE17
, PCR.PCR_ATTRIBUTE18
, PCR.PCR_ATTRIBUTE19
, PCR.PCR_ATTRIBUTE20
, PCR.PCR_ATTRIBUTE21
, PCR.PCR_ATTRIBUTE22
, PCR.PCR_ATTRIBUTE23
, PCR.PCR_ATTRIBUTE24
, PCR.PCR_ATTRIBUTE25
, PCR.PCR_ATTRIBUTE26
, PCR.PCR_ATTRIBUTE27
, PCR.PCR_ATTRIBUTE28
, PCR.PCR_ATTRIBUTE29
, PCR.PCR_ATTRIBUTE30
, PCR.LAST_UPDATE_DATE
, PCR.LAST_UPDATED_BY
, PCR.LAST_UPDATE_LOGIN
, PCR.CREATED_BY
, PCR.CREATION_DATE
, PCR.REQUEST_ID
, PCR.PROGRAM_APPLICATION_ID
, PCR.PROGRAM_ID
, PCR.PROGRAM_UPDATE_DATE
, PCR.OBJECT_VERSION_NUMBER
FROM BEN_PER_CM_TRGR_F PCR
, BEN_PER_CM_F PCM
, BEN_PER_IN_LER PIL
WHERE PCR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PCR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PCM.PER_CM_ID=PCR.PER_CM_ID
AND PCM.BUSINESS_GROUP_ID+0=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+0
AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL )