VIEW: APPS.BEN_PRTT_PREM

Source

View Text - Preformatted

SELECT ppe.PRTT_PREM_ID ,ppe.EFFECTIVE_START_DATE ,ppe.EFFECTIVE_END_DATE ,ppe.STD_PREM_UOM ,ppe.STD_PREM_VAL ,ppe.ACTL_PREM_ID ,ppe.PRTT_ENRT_RSLT_ID ,ppe.PER_IN_LER_ID ,ppe.BUSINESS_GROUP_ID ,ppe.PPE_ATTRIBUTE_CATEGORY ,ppe.PPE_ATTRIBUTE1 ,ppe.PPE_ATTRIBUTE2 ,ppe.PPE_ATTRIBUTE3 ,ppe.PPE_ATTRIBUTE4 ,ppe.PPE_ATTRIBUTE5 ,ppe.PPE_ATTRIBUTE6 ,ppe.PPE_ATTRIBUTE7 ,ppe.PPE_ATTRIBUTE8 ,ppe.PPE_ATTRIBUTE9 ,ppe.PPE_ATTRIBUTE10 ,ppe.PPE_ATTRIBUTE11 ,ppe.PPE_ATTRIBUTE12 ,ppe.PPE_ATTRIBUTE13 ,ppe.PPE_ATTRIBUTE14 ,ppe.PPE_ATTRIBUTE15 ,ppe.PPE_ATTRIBUTE16 ,ppe.PPE_ATTRIBUTE17 ,ppe.PPE_ATTRIBUTE18 ,ppe.PPE_ATTRIBUTE19 ,ppe.PPE_ATTRIBUTE20 ,ppe.PPE_ATTRIBUTE21 ,ppe.PPE_ATTRIBUTE22 ,ppe.PPE_ATTRIBUTE23 ,ppe.PPE_ATTRIBUTE24 ,ppe.PPE_ATTRIBUTE25 ,ppe.PPE_ATTRIBUTE26 ,ppe.PPE_ATTRIBUTE27 ,ppe.PPE_ATTRIBUTE28 ,ppe.PPE_ATTRIBUTE29 ,ppe.PPE_ATTRIBUTE30 ,ppe.LAST_UPDATE_DATE ,ppe.LAST_UPDATED_BY ,ppe.LAST_UPDATE_LOGIN ,ppe.CREATED_BY ,ppe.CREATION_DATE ,ppe.OBJECT_VERSION_NUMBER ,ppe.REQUEST_ID ,ppe.PROGRAM_APPLICATION_ID ,ppe.PROGRAM_ID ,ppe.PROGRAM_UPDATE_DATE from BEN_PRTT_PREM_F ppe , ben_per_in_ler pil WHERE ppe.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and ppe.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and pil.per_in_ler_id=ppe.per_in_ler_id and pil.business_group_id+0=ppe.business_group_id+0 and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

View Text - HTML Formatted

SELECT PPE.PRTT_PREM_ID
, PPE.EFFECTIVE_START_DATE
, PPE.EFFECTIVE_END_DATE
, PPE.STD_PREM_UOM
, PPE.STD_PREM_VAL
, PPE.ACTL_PREM_ID
, PPE.PRTT_ENRT_RSLT_ID
, PPE.PER_IN_LER_ID
, PPE.BUSINESS_GROUP_ID
, PPE.PPE_ATTRIBUTE_CATEGORY
, PPE.PPE_ATTRIBUTE1
, PPE.PPE_ATTRIBUTE2
, PPE.PPE_ATTRIBUTE3
, PPE.PPE_ATTRIBUTE4
, PPE.PPE_ATTRIBUTE5
, PPE.PPE_ATTRIBUTE6
, PPE.PPE_ATTRIBUTE7
, PPE.PPE_ATTRIBUTE8
, PPE.PPE_ATTRIBUTE9
, PPE.PPE_ATTRIBUTE10
, PPE.PPE_ATTRIBUTE11
, PPE.PPE_ATTRIBUTE12
, PPE.PPE_ATTRIBUTE13
, PPE.PPE_ATTRIBUTE14
, PPE.PPE_ATTRIBUTE15
, PPE.PPE_ATTRIBUTE16
, PPE.PPE_ATTRIBUTE17
, PPE.PPE_ATTRIBUTE18
, PPE.PPE_ATTRIBUTE19
, PPE.PPE_ATTRIBUTE20
, PPE.PPE_ATTRIBUTE21
, PPE.PPE_ATTRIBUTE22
, PPE.PPE_ATTRIBUTE23
, PPE.PPE_ATTRIBUTE24
, PPE.PPE_ATTRIBUTE25
, PPE.PPE_ATTRIBUTE26
, PPE.PPE_ATTRIBUTE27
, PPE.PPE_ATTRIBUTE28
, PPE.PPE_ATTRIBUTE29
, PPE.PPE_ATTRIBUTE30
, PPE.LAST_UPDATE_DATE
, PPE.LAST_UPDATED_BY
, PPE.LAST_UPDATE_LOGIN
, PPE.CREATED_BY
, PPE.CREATION_DATE
, PPE.OBJECT_VERSION_NUMBER
, PPE.REQUEST_ID
, PPE.PROGRAM_APPLICATION_ID
, PPE.PROGRAM_ID
, PPE.PROGRAM_UPDATE_DATE
FROM BEN_PRTT_PREM_F PPE
, BEN_PER_IN_LER PIL
WHERE PPE.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PPE.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PIL.PER_IN_LER_ID=PPE.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID+0=PPE.BUSINESS_GROUP_ID+0
AND PIL.PER_IN_LER_STAT_CD NOT IN ('VOIDD'
, 'BCKDT')