VIEW: APPS.BEN_ASNT_SET_RT_D

Source

View Text - Preformatted

SELECT ASR.ASNT_SET_RT_ID , ASR.EFFECTIVE_START_DATE , ASR.EFFECTIVE_END_DATE , VPR.NAME , HSA.ASSIGNMENT_SET_NAME , ASR.ORDR_NUM , ASR.EXCLD_FLAG , ASR.LAST_UPDATE_DATE , FUSER.USER_NAME FROM BEN_ASNT_SET_RT_F ASR ,FND_USER FUSER ,BEN_VRBL_RT_PRFL_F VPR ,HR_ASSIGNMENT_SETS HSA WHERE ASR.LAST_UPDATED_BY = FUSER.USER_ID (+) AND ASR.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID AND ASR.ASSIGNMENT_SET_ID = HSA.ASSIGNMENT_SET_ID AND asr.effective_start_date BETWEEN vpr.effective_start_date (+) and vpr.effective_end_date(+)

View Text - HTML Formatted

SELECT ASR.ASNT_SET_RT_ID
, ASR.EFFECTIVE_START_DATE
, ASR.EFFECTIVE_END_DATE
, VPR.NAME
, HSA.ASSIGNMENT_SET_NAME
, ASR.ORDR_NUM
, ASR.EXCLD_FLAG
, ASR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ASNT_SET_RT_F ASR
, FND_USER FUSER
, BEN_VRBL_RT_PRFL_F VPR
, HR_ASSIGNMENT_SETS HSA
WHERE ASR.LAST_UPDATED_BY = FUSER.USER_ID (+)
AND ASR.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID
AND ASR.ASSIGNMENT_SET_ID = HSA.ASSIGNMENT_SET_ID
AND ASR.EFFECTIVE_START_DATE BETWEEN VPR.EFFECTIVE_START_DATE (+)
AND VPR.EFFECTIVE_END_DATE(+)