VIEW: APPS.BEN_PRTT_PREM_X

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 trunc(sysdate) between ppe.effective_start_date and ppe.effective_end_date and pil.per_in_ler_id=ppe.per_in_ler_id and pil.business_group_id=ppe.business_group_id

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 TRUNC(SYSDATE) BETWEEN PPE.EFFECTIVE_START_DATE
AND PPE.EFFECTIVE_END_DATE
AND PIL.PER_IN_LER_ID=PPE.PER_IN_LER_ID
AND PIL.BUSINESS_GROUP_ID=PPE.BUSINESS_GROUP_ID