VIEW: APPS.BEN_ELIG_QUAL_TITL_PRTE_D

Source

View Text - Preformatted

SELECT EQT.rowid ,EQT.elig_qual_titl_prte_id ,EQT.effective_START_DATE ,EQT.effective_END_DATE ,ELP.name ,EQT.excld_flag ,EQT.title ,QT.name , EQT.CRITERIA_SCORE , EQT.CRITERIA_WEIGHT ,EQT.LAST_UPDATE_DATE ,FUSER.USER_NAME FROM BEN_ELIG_qual_titl_PRTE_F EQT, FND_USER FUSER, BEN_ELIGY_PRFL_F ELP, PER_QUALIFICATION_TYPES QT WHERE FUSER.USER_ID (+)= EQT.LAST_UPDATED_BY AND ELP.ELIGY_PRFL_ID (+) = EQT.ELIGY_PRFL_ID AND QT.qualification_type_id (+) = EQT.qualification_type_id AND eqt.effective_start_date BETWEEN elp.effective_start_date (+) and elp.effective_end_date(+)

View Text - HTML Formatted

SELECT EQT.ROWID
, EQT.ELIG_QUAL_TITL_PRTE_ID
, EQT.EFFECTIVE_START_DATE
, EQT.EFFECTIVE_END_DATE
, ELP.NAME
, EQT.EXCLD_FLAG
, EQT.TITLE
, QT.NAME
, EQT.CRITERIA_SCORE
, EQT.CRITERIA_WEIGHT
, EQT.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_QUAL_TITL_PRTE_F EQT
, FND_USER FUSER
, BEN_ELIGY_PRFL_F ELP
, PER_QUALIFICATION_TYPES QT
WHERE FUSER.USER_ID (+)= EQT.LAST_UPDATED_BY
AND ELP.ELIGY_PRFL_ID (+) = EQT.ELIGY_PRFL_ID
AND QT.QUALIFICATION_TYPE_ID (+) = EQT.QUALIFICATION_TYPE_ID
AND EQT.EFFECTIVE_START_DATE BETWEEN ELP.EFFECTIVE_START_DATE (+)
AND ELP.EFFECTIVE_END_DATE(+)