Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PRTT_ENRT_ACTN_V |
SELECT PEA.ROWID ROW_ID
, PEA.PRTT_ENRT_ACTN_ID
, PEA.EFFECTIVE_START_DATE
, PEA.EFFECTIVE_END_DATE
, PEA.CMPLTD_DT
, PEA.DUE_DT
, PEA.ELIG_CVRD_DPNT_ID
, PEA.PL_BNF_ID
, PEA.RQD_FLAG
, PEA.PRTT_ENRT_RSLT_ID
, PEA.ACTN_TYP_ID
, PEA.PER_IN_LER_ID
, PEA.BUSINESS_GROUP_ID
, PEA.PEA_ATTRIBUTE_CATEGORY
, PEA.PEA_ATTRIBUTE1
, PEA.PEA_ATTRIBUTE2
, PEA.PEA_ATTRIBUTE3
, PEA.PEA_ATTRIBUTE4
, PEA.PEA_ATTRIBUTE5
, PEA.PEA_ATTRIBUTE6
, PEA.PEA_ATTRIBUTE7
, PEA.PEA_ATTRIBUTE8
, PEA.PEA_ATTRIBUTE9
, PEA.PEA_ATTRIBUTE10
, PEA.PEA_ATTRIBUTE11
, PEA.PEA_ATTRIBUTE12
, PEA.PEA_ATTRIBUTE13
, PEA.PEA_ATTRIBUTE14
, PEA.PEA_ATTRIBUTE15
, PEA.PEA_ATTRIBUTE16
, PEA.PEA_ATTRIBUTE17
, PEA.PEA_ATTRIBUTE18
, PEA.PEA_ATTRIBUTE19
, PEA.PEA_ATTRIBUTE20
, PEA.PEA_ATTRIBUTE21
, PEA.PEA_ATTRIBUTE22
, PEA.PEA_ATTRIBUTE23
, PEA.PEA_ATTRIBUTE24
, PEA.PEA_ATTRIBUTE25
, PEA.PEA_ATTRIBUTE26
, PEA.PEA_ATTRIBUTE27
, PEA.PEA_ATTRIBUTE28
, PEA.PEA_ATTRIBUTE29
, PEA.PEA_ATTRIBUTE30
, PEA.LAST_UPDATE_DATE
, PEA.LAST_UPDATED_BY
, PEA.LAST_UPDATE_LOGIN
, PEA.CREATED_BY
, PEA.CREATION_DATE
, PEA.OBJECT_VERSION_NUMBER
, PEA.REQUEST_ID
, PEA.PROGRAM_APPLICATION_ID
, PEA.PROGRAM_ID
, PEA.PROGRAM_UPDATE_DATE
FROM BEN_PRTT_ENRT_ACTN_F PEA
, BEN_PER_IN_LER PIL
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PEA.EFFECTIVE_START_DATE
AND PEA.EFFECTIVE_END_DATE
AND PIL.PER_IN_LER_ID(+)=PEA.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID(+)=PEA.BUSINESS_GROUP_ID+0
AND ( PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT') OR PIL.PER_IN_LER_STAT_CD IS NULL )