Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PSTN_RT_V |
SELECT PST.ROWID
, PSTN_RT_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, VRBL_RT_PRFL_ID
, EXCLD_FLAG
, POSITION_ID
, ORDR_NUM
, PST_ATTRIBUTE_CATEGORY
, PST_ATTRIBUTE1
, PST_ATTRIBUTE2
, PST_ATTRIBUTE3
, PST_ATTRIBUTE4
, PST_ATTRIBUTE5
, PST_ATTRIBUTE6
, PST_ATTRIBUTE7
, PST_ATTRIBUTE8
, PST_ATTRIBUTE9
, PST_ATTRIBUTE10
, PST_ATTRIBUTE11
, PST_ATTRIBUTE12
, PST_ATTRIBUTE13
, PST_ATTRIBUTE14
, PST_ATTRIBUTE15
, PST_ATTRIBUTE16
, PST_ATTRIBUTE17
, PST_ATTRIBUTE18
, PST_ATTRIBUTE19
, PST_ATTRIBUTE20
, PST_ATTRIBUTE21
, PST_ATTRIBUTE22
, PST_ATTRIBUTE23
, PST_ATTRIBUTE24
, PST_ATTRIBUTE25
, PST_ATTRIBUTE26
, PST_ATTRIBUTE27
, PST_ATTRIBUTE28
, PST_ATTRIBUTE29
, PST_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_PSTN_RT_F PST
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE