Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PL_R_OIPL_PREM_BY_MO_V |
SELECT PBM.ROWID ROW_ID
, PBM.PL_R_OIPL_PREM_BY_MO_ID
, PBM.EFFECTIVE_START_DATE
, PBM.EFFECTIVE_END_DATE
, PBM.MNL_ADJ_FLAG
, PBM.MO_NUM
, PBM.YR_NUM
, PBM.VAL
, PBM.UOM
, PBM.PRTTS_NUM
, PBM.ACTL_PREM_ID
, PBM.BUSINESS_GROUP_ID
, PBM.COST_ALLOCATION_KEYFLEX_ID
, PBM.PBM_ATTRIBUTE_CATEGORY
, PBM.PBM_ATTRIBUTE1
, PBM.PBM_ATTRIBUTE2
, PBM.PBM_ATTRIBUTE3
, PBM.PBM_ATTRIBUTE4
, PBM.PBM_ATTRIBUTE5
, PBM.PBM_ATTRIBUTE6
, PBM.PBM_ATTRIBUTE7
, PBM.PBM_ATTRIBUTE8
, PBM.PBM_ATTRIBUTE9
, PBM.PBM_ATTRIBUTE10
, PBM.PBM_ATTRIBUTE11
, PBM.PBM_ATTRIBUTE12
, PBM.PBM_ATTRIBUTE13
, PBM.PBM_ATTRIBUTE14
, PBM.PBM_ATTRIBUTE15
, PBM.PBM_ATTRIBUTE16
, PBM.PBM_ATTRIBUTE17
, PBM.PBM_ATTRIBUTE18
, PBM.PBM_ATTRIBUTE19
, PBM.PBM_ATTRIBUTE20
, PBM.PBM_ATTRIBUTE21
, PBM.PBM_ATTRIBUTE22
, PBM.PBM_ATTRIBUTE23
, PBM.PBM_ATTRIBUTE24
, PBM.PBM_ATTRIBUTE25
, PBM.PBM_ATTRIBUTE26
, PBM.PBM_ATTRIBUTE27
, PBM.PBM_ATTRIBUTE28
, PBM.PBM_ATTRIBUTE29
, PBM.PBM_ATTRIBUTE30
, PBM.LAST_UPDATE_DATE
, PBM.LAST_UPDATED_BY
, PBM.LAST_UPDATE_LOGIN
, PBM.CREATED_BY
, PBM.CREATION_DATE
, PBM.OBJECT_VERSION_NUMBER
, PBM.REQUEST_ID
, PBM.PROGRAM_ID
, PBM.PROGRAM_APPLICATION_ID
, PBM.PROGRAM_UPDATE_DATE
FROM BEN_PL_R_OIPL_PREM_BY_MO_F PBM
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PBM.EFFECTIVE_START_DATE
AND PBM.EFFECTIVE_END_DATE