Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_ACTY_RT_PYMT_SCHED |
SELECT 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
WHERE APF.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND APF.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))