VIEW: APPS.BEN_LVG_RSN_RT_D

Source

View Text - Preformatted

SELECT LRN.ROWID ROW_ID, LRN.LVG_RSN_RT_ID, LRN.EFFECTIVE_START_DATE, LRN.EFFECTIVE_END_DATE, LRN.EXCLD_FLAG, VPR.NAME, HL.MEANING, LRN.ORDR_NUM , LRN.LAST_UPDATE_DATE, FUSER.USER_NAME FROM BEN_LVG_RSN_RT_F LRN , FND_USER_VIEW FUSER , HR_LOOKUPS HL , BEN_VRBL_RT_PRFL_F VPR WHERE FUSER.USER_ID(+) = LRN.LAST_UPDATED_BY AND HL.LOOKUP_TYPE = 'LEAV_REAS' AND HL.LOOKUP_CODE = LRN.LVG_RSN_CD and LRN.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID AND lrn.effective_start_date BETWEEN vpr.effective_start_date (+) and vpr.effective_end_date(+)

View Text - HTML Formatted

SELECT LRN.ROWID ROW_ID
, LRN.LVG_RSN_RT_ID
, LRN.EFFECTIVE_START_DATE
, LRN.EFFECTIVE_END_DATE
, LRN.EXCLD_FLAG
, VPR.NAME
, HL.MEANING
, LRN.ORDR_NUM
, LRN.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_LVG_RSN_RT_F LRN
, FND_USER_VIEW FUSER
, HR_LOOKUPS HL
, BEN_VRBL_RT_PRFL_F VPR
WHERE FUSER.USER_ID(+) = LRN.LAST_UPDATED_BY
AND HL.LOOKUP_TYPE = 'LEAV_REAS'
AND HL.LOOKUP_CODE = LRN.LVG_RSN_CD
AND LRN.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID
AND LRN.EFFECTIVE_START_DATE BETWEEN VPR.EFFECTIVE_START_DATE (+)
AND VPR.EFFECTIVE_END_DATE(+)