VIEW: APPS.BEN_PRTT_ENRT_CTFN_PRVDD_V

Source

View Text - Preformatted

SELECT PCS.ROWID ROW_ID , PCS.PRTT_ENRT_CTFN_PRVDD_ID , PCS.EFFECTIVE_START_DATE , PCS.EFFECTIVE_END_DATE , PCS.ENRT_CTFN_RQD_FLAG , PCS.ENRT_CTFN_TYP_CD , PCS.ENRT_CTFN_RECD_DT , PCS.ENRT_CTFN_DND_DT , PCS.ENRT_R_BNFT_CTFN_CD , PCS.PRTT_ENRT_RSLT_ID , PCS.PRTT_ENRT_ACTN_ID , PCS.BUSINESS_GROUP_ID , PCS.PCS_ATTRIBUTE_CATEGORY , PCS.PCS_ATTRIBUTE1 , PCS.PCS_ATTRIBUTE2 , PCS.PCS_ATTRIBUTE3 , PCS.PCS_ATTRIBUTE4 , PCS.PCS_ATTRIBUTE5 , PCS.PCS_ATTRIBUTE6 , PCS.PCS_ATTRIBUTE7 , PCS.PCS_ATTRIBUTE8 , PCS.PCS_ATTRIBUTE9 , PCS.PCS_ATTRIBUTE10 , PCS.PCS_ATTRIBUTE11 , PCS.PCS_ATTRIBUTE12 , PCS.PCS_ATTRIBUTE13 , PCS.PCS_ATTRIBUTE14 , PCS.PCS_ATTRIBUTE15 , PCS.PCS_ATTRIBUTE16 , PCS.PCS_ATTRIBUTE17 , PCS.PCS_ATTRIBUTE18 , PCS.PCS_ATTRIBUTE19 , PCS.PCS_ATTRIBUTE20 , PCS.PCS_ATTRIBUTE21 , PCS.PCS_ATTRIBUTE22 , PCS.PCS_ATTRIBUTE23 , PCS.PCS_ATTRIBUTE24 , PCS.PCS_ATTRIBUTE25 , PCS.PCS_ATTRIBUTE26 , PCS.PCS_ATTRIBUTE27 , PCS.PCS_ATTRIBUTE28 , PCS.PCS_ATTRIBUTE29 , PCS.PCS_ATTRIBUTE30 , PCS.LAST_UPDATE_DATE , PCS.LAST_UPDATED_BY , PCS.LAST_UPDATE_LOGIN , PCS.CREATED_BY , PCS.CREATION_DATE , PCS.REQUEST_ID , PCS.PROGRAM_APPLICATION_ID , PCS.PROGRAM_ID , PCS.PROGRAM_UPDATE_DATE , PCS.OBJECT_VERSION_NUMBER FROM BEN_PRTT_ENRT_CTFN_PRVDD_F PCS , 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 PCS.EFFECTIVE_START_DATE AND PCS.EFFECTIVE_END_DATE and pea.prtt_enrt_actn_id=pcs.prtt_enrt_actn_id and pea.business_group_id+0=pcs.business_group_id and pea.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND pea.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) 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 PCS.ROWID ROW_ID
, PCS.PRTT_ENRT_CTFN_PRVDD_ID
, PCS.EFFECTIVE_START_DATE
, PCS.EFFECTIVE_END_DATE
, PCS.ENRT_CTFN_RQD_FLAG
, PCS.ENRT_CTFN_TYP_CD
, PCS.ENRT_CTFN_RECD_DT
, PCS.ENRT_CTFN_DND_DT
, PCS.ENRT_R_BNFT_CTFN_CD
, PCS.PRTT_ENRT_RSLT_ID
, PCS.PRTT_ENRT_ACTN_ID
, PCS.BUSINESS_GROUP_ID
, PCS.PCS_ATTRIBUTE_CATEGORY
, PCS.PCS_ATTRIBUTE1
, PCS.PCS_ATTRIBUTE2
, PCS.PCS_ATTRIBUTE3
, PCS.PCS_ATTRIBUTE4
, PCS.PCS_ATTRIBUTE5
, PCS.PCS_ATTRIBUTE6
, PCS.PCS_ATTRIBUTE7
, PCS.PCS_ATTRIBUTE8
, PCS.PCS_ATTRIBUTE9
, PCS.PCS_ATTRIBUTE10
, PCS.PCS_ATTRIBUTE11
, PCS.PCS_ATTRIBUTE12
, PCS.PCS_ATTRIBUTE13
, PCS.PCS_ATTRIBUTE14
, PCS.PCS_ATTRIBUTE15
, PCS.PCS_ATTRIBUTE16
, PCS.PCS_ATTRIBUTE17
, PCS.PCS_ATTRIBUTE18
, PCS.PCS_ATTRIBUTE19
, PCS.PCS_ATTRIBUTE20
, PCS.PCS_ATTRIBUTE21
, PCS.PCS_ATTRIBUTE22
, PCS.PCS_ATTRIBUTE23
, PCS.PCS_ATTRIBUTE24
, PCS.PCS_ATTRIBUTE25
, PCS.PCS_ATTRIBUTE26
, PCS.PCS_ATTRIBUTE27
, PCS.PCS_ATTRIBUTE28
, PCS.PCS_ATTRIBUTE29
, PCS.PCS_ATTRIBUTE30
, PCS.LAST_UPDATE_DATE
, PCS.LAST_UPDATED_BY
, PCS.LAST_UPDATE_LOGIN
, PCS.CREATED_BY
, PCS.CREATION_DATE
, PCS.REQUEST_ID
, PCS.PROGRAM_APPLICATION_ID
, PCS.PROGRAM_ID
, PCS.PROGRAM_UPDATE_DATE
, PCS.OBJECT_VERSION_NUMBER
FROM BEN_PRTT_ENRT_CTFN_PRVDD_F PCS
, 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 PCS.EFFECTIVE_START_DATE
AND PCS.EFFECTIVE_END_DATE
AND PEA.PRTT_ENRT_ACTN_ID=PCS.PRTT_ENRT_ACTN_ID
AND PEA.BUSINESS_GROUP_ID+0=PCS.BUSINESS_GROUP_ID
AND PEA.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PEA.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
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 )