Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PER_CM_USG_V |
SELECT PCU.ROWID ROW_ID
, PCU.PER_CM_USG_ID
, PCU.EFFECTIVE_START_DATE
, PCU.EFFECTIVE_END_DATE
, PCU.PER_CM_ID
, PCU.CM_TYP_USG_ID
, PCU.BUSINESS_GROUP_ID
, PCU.PCU_ATTRIBUTE_CATEGORY
, PCU.PCU_ATTRIBUTE1
, PCU.PCU_ATTRIBUTE2
, PCU.PCU_ATTRIBUTE3
, PCU.PCU_ATTRIBUTE4
, PCU.PCU_ATTRIBUTE5
, PCU.PCU_ATTRIBUTE6
, PCU.PCU_ATTRIBUTE7
, PCU.PCU_ATTRIBUTE8
, PCU.PCU_ATTRIBUTE9
, PCU.PCU_ATTRIBUTE10
, PCU.PCU_ATTRIBUTE11
, PCU.PCU_ATTRIBUTE12
, PCU.PCU_ATTRIBUTE13
, PCU.PCU_ATTRIBUTE14
, PCU.PCU_ATTRIBUTE15
, PCU.PCU_ATTRIBUTE16
, PCU.PCU_ATTRIBUTE17
, PCU.PCU_ATTRIBUTE18
, PCU.PCU_ATTRIBUTE19
, PCU.PCU_ATTRIBUTE20
, PCU.PCU_ATTRIBUTE21
, PCU.PCU_ATTRIBUTE22
, PCU.PCU_ATTRIBUTE23
, PCU.PCU_ATTRIBUTE24
, PCU.PCU_ATTRIBUTE25
, PCU.PCU_ATTRIBUTE26
, PCU.PCU_ATTRIBUTE27
, PCU.PCU_ATTRIBUTE28
, PCU.PCU_ATTRIBUTE29
, PCU.PCU_ATTRIBUTE30
, PCU.LAST_UPDATE_DATE
, PCU.LAST_UPDATED_BY
, PCU.LAST_UPDATE_LOGIN
, PCU.CREATED_BY
, PCU.CREATION_DATE
, PCU.REQUEST_ID
, PCU.PROGRAM_APPLICATION_ID
, PCU.PROGRAM_ID
, PCU.PROGRAM_UPDATE_DATE
, PCU.OBJECT_VERSION_NUMBER
FROM BEN_PER_CM_USG_F PCU
, BEN_PER_CM_F PCM
, BEN_PER_IN_LER PIL
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PCU.EFFECTIVE_START_DATE
AND PCU.EFFECTIVE_END_DATE
AND PCM.PER_CM_ID=PCU.PER_CM_ID
AND PCM.BUSINESS_GROUP_ID+0=PCU.BUSINESS_GROUP_ID
AND PCU.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 )