VIEW: APPS.BEN_PRTT_ENRT_ACTN_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )