VIEW: APPS.BEN_WV_PRTN_RSN_CTFN_PL_D

Source

View Text - Preformatted

SELECT wcn.rowid row_id, wcn.wv_prtn_rsn_ctfn_pl_id, wcn.effective_start_date, wcn.effective_end_date, ff.formula_name, wv_prtn_ctfn_typ.meaning, lack_ctfn_sspnd_wvr.meaning, rqd.meaning, pfd.meaning, wcn.last_update_date, fuser.last_updated_by from ben_wv_prtn_rsn_ctfn_pl_f wcn, fnd_user fuser, hr_lookups wv_prtn_ctfn_typ, hr_lookups lack_ctfn_sspnd_wvr, hr_lookups rqd, hr_lookups pfd, ff_formulas_f ff WHERE fuser.user_id(+) = wcn.last_updated_by AND wv_prtn_ctfn_typ.lookup_code(+) = wcn.wv_prtn_ctfn_typ_cd AND wv_prtn_ctfn_typ.lookup_type(+) = 'BEN_WV_PRTN_CTFN_TYP' AND ff.formula_type_id(+)= wcn.ctfn_rqd_when_rl AND wcn.effective_start_date BETWEEN ff.effective_start_date(+) AND ff.effective_end_date(+) AND rqd.lookup_code(+) = wcn.rqd_flag AND rqd.lookup_type(+) = 'YES_NO' AND pfd.lookup_code(+) = wcn.pfd_flag AND pfd.lookup_type(+) = 'YES_NO' AND lack_ctfn_sspnd_wvr.lookup_code(+) = wcn.lack_ctfn_sspnd_wvr_flag AND lack_ctfn_sspnd_wvr.lookup_type(+) = 'YES_NO'

View Text - HTML Formatted

SELECT WCN.ROWID ROW_ID
, WCN.WV_PRTN_RSN_CTFN_PL_ID
, WCN.EFFECTIVE_START_DATE
, WCN.EFFECTIVE_END_DATE
, FF.FORMULA_NAME
, WV_PRTN_CTFN_TYP.MEANING
, LACK_CTFN_SSPND_WVR.MEANING
, RQD.MEANING
, PFD.MEANING
, WCN.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_WV_PRTN_RSN_CTFN_PL_F WCN
, FND_USER FUSER
, HR_LOOKUPS WV_PRTN_CTFN_TYP
, HR_LOOKUPS LACK_CTFN_SSPND_WVR
, HR_LOOKUPS RQD
, HR_LOOKUPS PFD
, FF_FORMULAS_F FF
WHERE FUSER.USER_ID(+) = WCN.LAST_UPDATED_BY
AND WV_PRTN_CTFN_TYP.LOOKUP_CODE(+) = WCN.WV_PRTN_CTFN_TYP_CD
AND WV_PRTN_CTFN_TYP.LOOKUP_TYPE(+) = 'BEN_WV_PRTN_CTFN_TYP'
AND FF.FORMULA_TYPE_ID(+)= WCN.CTFN_RQD_WHEN_RL
AND WCN.EFFECTIVE_START_DATE BETWEEN FF.EFFECTIVE_START_DATE(+)
AND FF.EFFECTIVE_END_DATE(+)
AND RQD.LOOKUP_CODE(+) = WCN.RQD_FLAG
AND RQD.LOOKUP_TYPE(+) = 'YES_NO'
AND PFD.LOOKUP_CODE(+) = WCN.PFD_FLAG
AND PFD.LOOKUP_TYPE(+) = 'YES_NO'
AND LACK_CTFN_SSPND_WVR.LOOKUP_CODE(+) = WCN.LACK_CTFN_SSPND_WVR_FLAG
AND LACK_CTFN_SSPND_WVR.LOOKUP_TYPE(+) = 'YES_NO'