Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PRTT_PREM_BY_MO_V |
SELECT PRM.ROWID ROW_ID
, PRM.PRTT_PREM_BY_MO_ID
, PRM.EFFECTIVE_START_DATE
, PRM.EFFECTIVE_END_DATE
, PRM.MNL_ADJ_FLAG
, PRM.MO_NUM
, PRM.YR_NUM
, PRM.ANTCPD_PRTT_CNTR_UOM
, PRM.ANTCPD_PRTT_CNTR_VAL
, PRM.VAL
, PRM.CR_VAL
, PRM.CR_MNL_ADJ_FLAG
, PRM.ALCTD_VAL_FLAG
, PRM.UOM
, PRM.PRTT_PREM_ID
, PRM.COST_ALLOCATION_KEYFLEX_ID
, PRM.BUSINESS_GROUP_ID
, PRM.PRM_ATTRIBUTE_CATEGORY
, PRM.PRM_ATTRIBUTE1
, PRM.PRM_ATTRIBUTE2
, PRM.PRM_ATTRIBUTE3
, PRM.PRM_ATTRIBUTE4
, PRM.PRM_ATTRIBUTE5
, PRM.PRM_ATTRIBUTE6
, PRM.PRM_ATTRIBUTE7
, PRM.PRM_ATTRIBUTE8
, PRM.PRM_ATTRIBUTE9
, PRM.PRM_ATTRIBUTE10
, PRM.PRM_ATTRIBUTE11
, PRM.PRM_ATTRIBUTE12
, PRM.PRM_ATTRIBUTE13
, PRM.PRM_ATTRIBUTE14
, PRM.PRM_ATTRIBUTE15
, PRM.PRM_ATTRIBUTE16
, PRM.PRM_ATTRIBUTE17
, PRM.PRM_ATTRIBUTE18
, PRM.PRM_ATTRIBUTE19
, PRM.PRM_ATTRIBUTE20
, PRM.PRM_ATTRIBUTE21
, PRM.PRM_ATTRIBUTE22
, PRM.PRM_ATTRIBUTE23
, PRM.PRM_ATTRIBUTE24
, PRM.PRM_ATTRIBUTE25
, PRM.PRM_ATTRIBUTE26
, PRM.PRM_ATTRIBUTE27
, PRM.PRM_ATTRIBUTE28
, PRM.PRM_ATTRIBUTE29
, PRM.PRM_ATTRIBUTE30
, PRM.LAST_UPDATE_DATE
, PRM.LAST_UPDATED_BY
, PRM.LAST_UPDATE_LOGIN
, PRM.CREATED_BY
, PRM.CREATION_DATE
, PRM.OBJECT_VERSION_NUMBER
, PRM.REQUEST_ID
, PRM.PROGRAM_APPLICATION_ID
, PRM.PROGRAM_ID
, PRM.PROGRAM_UPDATE_DATE
FROM BEN_PRTT_PREM_BY_MO_F PRM
, BEN_PRTT_PREM_F PPE
, BEN_PER_IN_LER PIL
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PRM.EFFECTIVE_START_DATE
AND PRM.EFFECTIVE_END_DATE
AND PPE.PRTT_PREM_ID=PRM.PRTT_PREM_ID
AND PPE.BUSINESS_GROUP_ID+0=PRM.BUSINESS_GROUP_ID
AND PRM.EFFECTIVE_START_DATE 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