Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PTD_LMT |
SELECT PDL.PTD_LMT_ID
, PDL.EFFECTIVE_START_DATE
, PDL.EFFECTIVE_END_DATE
, PDL.NAME
, PDL.MX_COMP_TO_CNSDR
, PDL.MX_VAL
, PDL.MX_PCT_VAL
, PDL.PTD_LMT_CALC_RL
, PDL.LMT_DET_CD
, PDL.COMP_LVL_FCTR_ID
, PDL.BALANCE_TYPE_ID
, PDL.BUSINESS_GROUP_ID
, PDL.PDL_ATTRIBUTE_CATEGORY
, PDL.PDL_ATTRIBUTE1
, PDL.PDL_ATTRIBUTE2
, PDL.PDL_ATTRIBUTE3
, PDL.PDL_ATTRIBUTE4
, PDL.PDL_ATTRIBUTE5
, PDL.PDL_ATTRIBUTE6
, PDL.PDL_ATTRIBUTE7
, PDL.PDL_ATTRIBUTE8
, PDL.PDL_ATTRIBUTE9
, PDL.PDL_ATTRIBUTE10
, PDL.PDL_ATTRIBUTE11
, PDL.PDL_ATTRIBUTE12
, PDL.PDL_ATTRIBUTE13
, PDL.PDL_ATTRIBUTE14
, PDL.PDL_ATTRIBUTE15
, PDL.PDL_ATTRIBUTE16
, PDL.PDL_ATTRIBUTE17
, PDL.PDL_ATTRIBUTE18
, PDL.PDL_ATTRIBUTE19
, PDL.PDL_ATTRIBUTE20
, PDL.PDL_ATTRIBUTE21
, PDL.PDL_ATTRIBUTE22
, PDL.PDL_ATTRIBUTE23
, PDL.PDL_ATTRIBUTE24
, PDL.PDL_ATTRIBUTE25
, PDL.PDL_ATTRIBUTE26
, PDL.PDL_ATTRIBUTE27
, PDL.PDL_ATTRIBUTE28
, PDL.PDL_ATTRIBUTE29
, PDL.PDL_ATTRIBUTE30
, PDL.LAST_UPDATE_DATE
, PDL.LAST_UPDATED_BY
, PDL.LAST_UPDATE_LOGIN
, PDL.CREATED_BY
, PDL.CREATION_DATE
, PDL.OBJECT_VERSION_NUMBER
FROM BEN_PTD_LMT_F PDL
WHERE PDL.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PDL.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))