VIEW: APPS.BEN_PL_DPNT_CVG_CTFN_D

Source

View Text - Preformatted

SELECT pnd.ROWID row_id, pnd.pl_dpnt_cvg_ctfn_id, pnd.effective_start_date, pnd.effective_end_date, pl.NAME, ctfn_rqd_when.formula_name, ctfn_typ.meaning, rqd.meaning, rlshp_typ.meaning, pnd.last_update_date, fuser.user_name FROM ben_pl_dpnt_cvg_ctfn_f pnd, fnd_user fuser, ben_pl_f pl, hr_lookups ctfn_typ, hr_lookups rlshp_typ, ff_formulas_f ctfn_rqd_when, hr_lookups rqd WHERE fuser.user_id(+) = pnd.last_updated_by AND pl.pl_id(+) = pnd.pl_id AND ctfn_typ.lookup_code(+) = pnd.dpnt_cvg_ctfn_typ_cd AND ctfn_typ.lookup_type(+) = 'BEN_DPNT_CVG_CTFN_TYP' AND rlshp_typ.lookup_code(+) = pnd.rlshp_typ_cd AND rlshp_typ.lookup_type(+) = 'CONTACT' AND ctfn_rqd_when.formula_id(+) = pnd.ctfn_rqd_when_rl AND pnd.effective_start_date BETWEEN ctfn_rqd_when.effective_start_date(+) AND ctfn_rqd_when.effective_end_date(+) AND rqd.lookup_code(+) = pnd.rqd_flag AND rqd.lookup_type(+) = 'YES_NO' AND pnd.effective_start_date BETWEEN pl.effective_start_date(+) AND pl.effective_end_date(+) AND pnd.effective_start_date BETWEEN ctfn_rqd_when.effective_start_date(+) AND ctfn_rqd_when.effective_end_date(+)

View Text - HTML Formatted

SELECT PND.ROWID ROW_ID
, PND.PL_DPNT_CVG_CTFN_ID
, PND.EFFECTIVE_START_DATE
, PND.EFFECTIVE_END_DATE
, PL.NAME
, CTFN_RQD_WHEN.FORMULA_NAME
, CTFN_TYP.MEANING
, RQD.MEANING
, RLSHP_TYP.MEANING
, PND.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PL_DPNT_CVG_CTFN_F PND
, FND_USER FUSER
, BEN_PL_F PL
, HR_LOOKUPS CTFN_TYP
, HR_LOOKUPS RLSHP_TYP
, FF_FORMULAS_F CTFN_RQD_WHEN
, HR_LOOKUPS RQD
WHERE FUSER.USER_ID(+) = PND.LAST_UPDATED_BY
AND PL.PL_ID(+) = PND.PL_ID
AND CTFN_TYP.LOOKUP_CODE(+) = PND.DPNT_CVG_CTFN_TYP_CD
AND CTFN_TYP.LOOKUP_TYPE(+) = 'BEN_DPNT_CVG_CTFN_TYP'
AND RLSHP_TYP.LOOKUP_CODE(+) = PND.RLSHP_TYP_CD
AND RLSHP_TYP.LOOKUP_TYPE(+) = 'CONTACT'
AND CTFN_RQD_WHEN.FORMULA_ID(+) = PND.CTFN_RQD_WHEN_RL
AND PND.EFFECTIVE_START_DATE BETWEEN CTFN_RQD_WHEN.EFFECTIVE_START_DATE(+)
AND CTFN_RQD_WHEN.EFFECTIVE_END_DATE(+)
AND RQD.LOOKUP_CODE(+) = PND.RQD_FLAG
AND RQD.LOOKUP_TYPE(+) = 'YES_NO'
AND PND.EFFECTIVE_START_DATE BETWEEN PL.EFFECTIVE_START_DATE(+)
AND PL.EFFECTIVE_END_DATE(+)
AND PND.EFFECTIVE_START_DATE BETWEEN CTFN_RQD_WHEN.EFFECTIVE_START_DATE(+)
AND CTFN_RQD_WHEN.EFFECTIVE_END_DATE(+)