VIEW: APPS.BEN_CVRD_DPNT_CTFN_PRVDD_D

Source

View Text - Preformatted

SELECT CCP.CVRD_DPNT_CTFN_PRVDD_ID , CCP.EFFECTIVE_START_DATE , CCP.EFFECTIVE_END_DATE , DPNT_DSGN_CTFN_TYP.MEANING , DPNT_DSGN_CTFN_RQD.MEANING , CCP.DPNT_DSGN_CTFN_RECD_DT , CCP.LAST_UPDATE_DATE , fuser.user_name from fnd_user_view fuser ,BEN_CVRD_DPNT_CTFN_PRVDD_F CCP ,hr_lookups DPNT_DSGN_CTFN_TYP ,hr_lookups DPNT_DSGN_CTFN_RQD WHERE fuser.user_id (+)= CCP.last_updated_by and DPNT_DSGN_CTFN_TYP.lookup_code (+)= CCP.DPNT_DSGN_CTFN_TYP_CD and DPNT_DSGN_CTFN_TYP.lookup_type (+)= 'BEN_DPNT_CVG_CTFN_TYP' and DPNT_DSGN_CTFN_RQD.lookup_code (+)= CCP.DPNT_DSGN_CTFN_RQD_FLAG and DPNT_DSGN_CTFN_RQD.lookup_type (+)= 'YES_NO'

View Text - HTML Formatted

SELECT CCP.CVRD_DPNT_CTFN_PRVDD_ID
, CCP.EFFECTIVE_START_DATE
, CCP.EFFECTIVE_END_DATE
, DPNT_DSGN_CTFN_TYP.MEANING
, DPNT_DSGN_CTFN_RQD.MEANING
, CCP.DPNT_DSGN_CTFN_RECD_DT
, CCP.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM FND_USER_VIEW FUSER
, BEN_CVRD_DPNT_CTFN_PRVDD_F CCP
, HR_LOOKUPS DPNT_DSGN_CTFN_TYP
, HR_LOOKUPS DPNT_DSGN_CTFN_RQD
WHERE FUSER.USER_ID (+)= CCP.LAST_UPDATED_BY
AND DPNT_DSGN_CTFN_TYP.LOOKUP_CODE (+)= CCP.DPNT_DSGN_CTFN_TYP_CD
AND DPNT_DSGN_CTFN_TYP.LOOKUP_TYPE (+)= 'BEN_DPNT_CVG_CTFN_TYP'
AND DPNT_DSGN_CTFN_RQD.LOOKUP_CODE (+)= CCP.DPNT_DSGN_CTFN_RQD_FLAG
AND DPNT_DSGN_CTFN_RQD.LOOKUP_TYPE (+)= 'YES_NO'