Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PRTT_PREM |
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')