Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PER_CM_TRGR_X |
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 TRUNC(SYSDATE) BETWEEN PCR.EFFECTIVE_START_DATE
AND PCR.EFFECTIVE_END_DATE
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 )