VIEW: APPS.BEN_LER_ENRT_CTFN_D

Source

View Text - Preformatted

SELECT lnc.ROWID ROW_ID, lnc.LER_ENRT_CTFN_ID ,lnc.EFFECTIVE_START_DATE ,lnc.EFFECTIVE_END_DATE ,RQD.MEANING ,ENRT_CTFN_TYP.MEANING ,CTFN_RQD_WHEN.FORMULA_NAME ,lnc.LAST_UPDATE_DATE ,fuser.LAST_UPDATED_BY from BEN_LER_ENRT_CTFN_F lnc, fnd_user fuser ,BEN_LER_RQRS_ENRT_CTFN_F LER_RQRS_ENRT_CTFN ,hr_lookups ENRT_CTFN_TYP ,hr_lookups RQD ,ff_formulas_f CTFN_RQD_WHEN where fuser.user_id (+)= lnc .last_updated_by and LER_RQRS_ENRT_CTFN.LER_RQRS_ENRT_CTFN_ID (+)= lnc .LER_RQRS_ENRT_CTFN_ID and ENRT_CTFN_TYP.lookup_code (+)= lnc .ENRT_CTFN_TYP_CD and ENRT_CTFN_TYP.lookup_type (+)= '' and RQD.lookup_code (+)= lnc .RQD_FLAG and RQD.lookup_type (+)= 'YES_NO' and CTFN_RQD_WHEN.formula_id (+)= lnc .CTFN_RQD_WHEN_RL and lnc .EFFECTIVE_START_DATE BETWEEN CTFN_RQD_WHEN.EFFECTIVE_START_DATE(+) and CTFN_RQD_WHEN.EFFECTIVE_END_DATE(+)

View Text - HTML Formatted

SELECT LNC.ROWID ROW_ID
, LNC.LER_ENRT_CTFN_ID
, LNC.EFFECTIVE_START_DATE
, LNC.EFFECTIVE_END_DATE
, RQD.MEANING
, ENRT_CTFN_TYP.MEANING
, CTFN_RQD_WHEN.FORMULA_NAME
, LNC.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_LER_ENRT_CTFN_F LNC
, FND_USER FUSER
, BEN_LER_RQRS_ENRT_CTFN_F LER_RQRS_ENRT_CTFN
, HR_LOOKUPS ENRT_CTFN_TYP
, HR_LOOKUPS RQD
, FF_FORMULAS_F CTFN_RQD_WHEN
WHERE FUSER.USER_ID (+)= LNC .LAST_UPDATED_BY
AND LER_RQRS_ENRT_CTFN.LER_RQRS_ENRT_CTFN_ID (+)= LNC .LER_RQRS_ENRT_CTFN_ID
AND ENRT_CTFN_TYP.LOOKUP_CODE (+)= LNC .ENRT_CTFN_TYP_CD
AND ENRT_CTFN_TYP.LOOKUP_TYPE (+)= ''
AND RQD.LOOKUP_CODE (+)= LNC .RQD_FLAG
AND RQD.LOOKUP_TYPE (+)= 'YES_NO'
AND CTFN_RQD_WHEN.FORMULA_ID (+)= LNC .CTFN_RQD_WHEN_RL
AND LNC .EFFECTIVE_START_DATE BETWEEN CTFN_RQD_WHEN.EFFECTIVE_START_DATE(+)
AND CTFN_RQD_WHEN.EFFECTIVE_END_DATE(+)