eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BEN_LOA_RSN_RT

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

View Text

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'))

Columns

Name
LOA_RSN_RT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
ORDR_NUM
EXCLD_FLAG
VRBL_RT_PRFL_ID
LOA_RSN_CD
LAR_ATTRIBUTE_CATEGORY
LAR_ATTRIBUTE1
LAR_ATTRIBUTE2
LAR_ATTRIBUTE3
LAR_ATTRIBUTE4
LAR_ATTRIBUTE5
LAR_ATTRIBUTE6
LAR_ATTRIBUTE7
LAR_ATTRIBUTE8
LAR_ATTRIBUTE9
LAR_ATTRIBUTE10
LAR_ATTRIBUTE11
LAR_ATTRIBUTE12
LAR_ATTRIBUTE13
LAR_ATTRIBUTE14
LAR_ATTRIBUTE15
LAR_ATTRIBUTE16
LAR_ATTRIBUTE17
LAR_ATTRIBUTE18
LAR_ATTRIBUTE19
LAR_ATTRIBUTE20
LAR_ATTRIBUTE21
LAR_ATTRIBUTE22
LAR_ATTRIBUTE23
LAR_ATTRIBUTE24
LAR_ATTRIBUTE25
LAR_ATTRIBUTE26
LAR_ATTRIBUTE27
LAR_ATTRIBUTE28
LAR_ATTRIBUTE29
LAR_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
ABSENCE_ATTENDANCE_TYPE_ID
ABS_ATTENDANCE_REASON_ID