VIEW: APPS.BEN_LOA_RSN_RT

Source

View Text - Preformatted

SELECT lar.LOA_RSN_RT_ID ,lar.EFFECTIVE_START_DATE ,lar.EFFECTIVE_END_DATE ,lar.BUSINESS_GROUP_ID ,lar.ORDR_NUM ,lar.EXCLD_FLAG ,lar.VRBL_RT_PRFL_ID ,lar.LOA_RSN_CD ,lar.LAR_ATTRIBUTE_CATEGORY ,lar.LAR_ATTRIBUTE1 ,lar.LAR_ATTRIBUTE2 ,lar.LAR_ATTRIBUTE3 ,lar.LAR_ATTRIBUTE4 ,lar.LAR_ATTRIBUTE5 ,lar.LAR_ATTRIBUTE6 ,lar.LAR_ATTRIBUTE7 ,lar.LAR_ATTRIBUTE8 ,lar.LAR_ATTRIBUTE9 ,lar.LAR_ATTRIBUTE10 ,lar.LAR_ATTRIBUTE11 ,lar.LAR_ATTRIBUTE12 ,lar.LAR_ATTRIBUTE13 ,lar.LAR_ATTRIBUTE14 ,lar.LAR_ATTRIBUTE15 ,lar.LAR_ATTRIBUTE16 ,lar.LAR_ATTRIBUTE17 ,lar.LAR_ATTRIBUTE18 ,lar.LAR_ATTRIBUTE19 ,lar.LAR_ATTRIBUTE20 ,lar.LAR_ATTRIBUTE21 ,lar.LAR_ATTRIBUTE22 ,lar.LAR_ATTRIBUTE23 ,lar.LAR_ATTRIBUTE24 ,lar.LAR_ATTRIBUTE25 ,lar.LAR_ATTRIBUTE26 ,lar.LAR_ATTRIBUTE27 ,lar.LAR_ATTRIBUTE28 ,lar.LAR_ATTRIBUTE29 ,lar.LAR_ATTRIBUTE30 ,lar.LAST_UPDATE_DATE ,lar.LAST_UPDATED_BY ,lar.LAST_UPDATE_LOGIN ,lar.CREATED_BY ,lar.CREATION_DATE ,lar.OBJECT_VERSION_NUMBER ,lar.ABSENCE_ATTENDANCE_TYPE_ID ,lar.ABS_ATTENDANCE_REASON_ID from BEN_LOA_RSN_RT_F lar WHERE lar.effective_start_date <= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid')) and lar.effective_end_date >= (select ss.effective_date from fnd_sessions ss where ss.session_id = userenv('sessionid'))

View Text - HTML Formatted

SELECT LAR.LOA_RSN_RT_ID
, LAR.EFFECTIVE_START_DATE
, LAR.EFFECTIVE_END_DATE
, LAR.BUSINESS_GROUP_ID
, LAR.ORDR_NUM
, LAR.EXCLD_FLAG
, LAR.VRBL_RT_PRFL_ID
, LAR.LOA_RSN_CD
, LAR.LAR_ATTRIBUTE_CATEGORY
, LAR.LAR_ATTRIBUTE1
, LAR.LAR_ATTRIBUTE2
, LAR.LAR_ATTRIBUTE3
, LAR.LAR_ATTRIBUTE4
, LAR.LAR_ATTRIBUTE5
, LAR.LAR_ATTRIBUTE6
, LAR.LAR_ATTRIBUTE7
, LAR.LAR_ATTRIBUTE8
, LAR.LAR_ATTRIBUTE9
, LAR.LAR_ATTRIBUTE10
, LAR.LAR_ATTRIBUTE11
, LAR.LAR_ATTRIBUTE12
, LAR.LAR_ATTRIBUTE13
, LAR.LAR_ATTRIBUTE14
, LAR.LAR_ATTRIBUTE15
, LAR.LAR_ATTRIBUTE16
, LAR.LAR_ATTRIBUTE17
, LAR.LAR_ATTRIBUTE18
, LAR.LAR_ATTRIBUTE19
, LAR.LAR_ATTRIBUTE20
, LAR.LAR_ATTRIBUTE21
, LAR.LAR_ATTRIBUTE22
, LAR.LAR_ATTRIBUTE23
, LAR.LAR_ATTRIBUTE24
, LAR.LAR_ATTRIBUTE25
, LAR.LAR_ATTRIBUTE26
, LAR.LAR_ATTRIBUTE27
, LAR.LAR_ATTRIBUTE28
, LAR.LAR_ATTRIBUTE29
, LAR.LAR_ATTRIBUTE30
, LAR.LAST_UPDATE_DATE
, LAR.LAST_UPDATED_BY
, LAR.LAST_UPDATE_LOGIN
, LAR.CREATED_BY
, LAR.CREATION_DATE
, LAR.OBJECT_VERSION_NUMBER
, LAR.ABSENCE_ATTENDANCE_TYPE_ID
, LAR.ABS_ATTENDANCE_REASON_ID
FROM BEN_LOA_RSN_RT_F LAR
WHERE LAR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND LAR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))