VIEW: APPS.BEN_PER_CM_TRGR_D

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )