VIEW: APPS.BEN_COMP_LVL_ACTY_RT_D

Source

View Text - Preformatted

SELECT BTR.ROWID ROW_ID , BTR.COMP_LVL_ACTY_RT_ID , BTR.EFFECTIVE_START_DATE , BTR.EFFECTIVE_END_DATE , DFLT.MEANING , COMP_LVL_FCTR.NAME , ACTY_BASE_RT.NAME , BTR.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY FROM BEN_COMP_LVL_ACTY_RT_F BTR, FND_USER FUSER ,BEN_COMP_LVL_FCTR COMP_LVL_FCTR ,BEN_ACTY_BASE_RT_F ACTY_BASE_RT ,HR_LOOKUPS DFLT WHERE FUSER.USER_ID (+)= BTR .LAST_UPDATED_BY AND COMP_LVL_FCTR.COMP_LVL_FCTR_ID (+)= BTR .COMP_LVL_FCTR_ID AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= BTR .ACTY_BASE_RT_ID AND DFLT.LOOKUP_CODE (+)= BTR .DFLT_FLAG AND DFLT.LOOKUP_TYPE (+)= 'YES_NO'

View Text - HTML Formatted

SELECT BTR.ROWID ROW_ID
, BTR.COMP_LVL_ACTY_RT_ID
, BTR.EFFECTIVE_START_DATE
, BTR.EFFECTIVE_END_DATE
, DFLT.MEANING
, COMP_LVL_FCTR.NAME
, ACTY_BASE_RT.NAME
, BTR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_COMP_LVL_ACTY_RT_F BTR
, FND_USER FUSER
, BEN_COMP_LVL_FCTR COMP_LVL_FCTR
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, HR_LOOKUPS DFLT
WHERE FUSER.USER_ID (+)= BTR .LAST_UPDATED_BY
AND COMP_LVL_FCTR.COMP_LVL_FCTR_ID (+)= BTR .COMP_LVL_FCTR_ID
AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= BTR .ACTY_BASE_RT_ID
AND DFLT.LOOKUP_CODE (+)= BTR .DFLT_FLAG
AND DFLT.LOOKUP_TYPE (+)= 'YES_NO'