View: BEN_ACTY_RT_PYMT_SCHED_V

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_ACTY_RT_PYMT_SCHED_V

View Text

SELECT APF.ROWID ROW_ID
, APF.ACTY_RT_PYMT_SCHED_ID
, APF.EFFECTIVE_START_DATE
, APF.EFFECTIVE_END_DATE
, APF.BUSINESS_GROUP_ID
, APF.PYMT_SCHED_RL
, APF.ACTY_BASE_RT_ID
, APF.PYMT_SCHED_CD
, APF.APF_ATTRIBUTE_CATEGORY
, APF.APF_ATTRIBUTE1
, APF.APF_ATTRIBUTE2
, APF.APF_ATTRIBUTE3
, APF.APF_ATTRIBUTE4
, APF.APF_ATTRIBUTE5
, APF.APF_ATTRIBUTE6
, APF.APF_ATTRIBUTE7
, APF.APF_ATTRIBUTE8
, APF.APF_ATTRIBUTE9
, APF.APF_ATTRIBUTE10
, APF.APF_ATTRIBUTE11
, APF.APF_ATTRIBUTE12
, APF.APF_ATTRIBUTE13
, APF.APF_ATTRIBUTE14
, APF.APF_ATTRIBUTE15
, APF.APF_ATTRIBUTE16
, APF.APF_ATTRIBUTE17
, APF.APF_ATTRIBUTE18
, APF.APF_ATTRIBUTE19
, APF.APF_ATTRIBUTE20
, APF.APF_ATTRIBUTE21
, APF.APF_ATTRIBUTE22
, APF.APF_ATTRIBUTE23
, APF.APF_ATTRIBUTE24
, APF.APF_ATTRIBUTE25
, APF.APF_ATTRIBUTE26
, APF.APF_ATTRIBUTE27
, APF.APF_ATTRIBUTE28
, APF.APF_ATTRIBUTE29
, APF.APF_ATTRIBUTE30
, APF.LAST_UPDATE_DATE
, APF.LAST_UPDATED_BY
, APF.LAST_UPDATE_LOGIN
, APF.CREATED_BY
, APF.CREATION_DATE
, APF.OBJECT_VERSION_NUMBER
FROM BEN_ACTY_RT_PYMT_SCHED_F APF
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN APF.EFFECTIVE_START_DATE
AND APF.EFFECTIVE_END_DATE

Columns