VIEW: APPS.BEN_QUAL_TITL_RT_D

Source

View Text - Preformatted

SELECT QTR.QUAL_TITL_RT_ID, QTR.EFFECTIVE_START_DATE, QTR.EFFECTIVE_END_DATE , PQT.NAME, QTR.TITLE, QTR.EXCLD_FLAG , VPR.NAME , QTR.ORDR_NUM , QTR.LAST_UPDATE_DATE, FUSER.USER_NAME FROM BEN_QUAL_TITL_RT_F QTR, FND_USER_VIEW FUSER, PER_QUALIFICATION_TYPES PQT, BEN_VRBL_RT_PRFL_F VPR WHERE FUSER.USER_ID(+) = QTR.LAST_UPDATED_BY AND PQT.QUALIFICATION_TYPE_ID = QTR.QUALIFICATION_TYPE_ID AND QTR.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID

View Text - HTML Formatted

SELECT QTR.QUAL_TITL_RT_ID
, QTR.EFFECTIVE_START_DATE
, QTR.EFFECTIVE_END_DATE
, PQT.NAME
, QTR.TITLE
, QTR.EXCLD_FLAG
, VPR.NAME
, QTR.ORDR_NUM
, QTR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_QUAL_TITL_RT_F QTR
, FND_USER_VIEW FUSER
, PER_QUALIFICATION_TYPES PQT
, BEN_VRBL_RT_PRFL_F VPR
WHERE FUSER.USER_ID(+) = QTR.LAST_UPDATED_BY
AND PQT.QUALIFICATION_TYPE_ID = QTR.QUALIFICATION_TYPE_ID
AND QTR.VRBL_RT_PRFL_ID = VPR.VRBL_RT_PRFL_ID