VIEW: APPS.BEN_CNTNG_PRTN_ELIG_PRFL_D

Source

View Text - Preformatted

SELECT cgp.ROWID row_id, cgp.cntng_prtn_elig_prfl_id, cgp.effective_start_date, cgp.effective_end_date, eligy_prfl.NAME, cgp.NAME, pymt_must_be_rcvd.meaning, cgp.pymt_must_be_rcvd_num, pymt_must_be_rcvd2.formula_name, cgp.last_update_date, fuser.user_name FROM ben_cntng_prtn_elig_prfl_f cgp, fnd_user fuser, ben_eligy_prfl_f eligy_prfl, hr_lookups pymt_must_be_rcvd, ff_formulas_f pymt_must_be_rcvd2 WHERE fuser.user_id(+) = cgp.last_updated_by AND eligy_prfl.eligy_prfl_id(+) = cgp.eligy_prfl_id AND pymt_must_be_rcvd.lookup_code(+) = cgp.pymt_must_be_rcvd_uom AND pymt_must_be_rcvd.lookup_type(+) = 'BEN_PYMT_MUST_BE_RECD' AND pymt_must_be_rcvd2.formula_id(+) = cgp.pymt_must_be_rcvd_rl AND cgp.effective_start_date BETWEEN pymt_must_be_rcvd2.effective_start_date(+) AND pymt_must_be_rcvd2.effective_end_date(+) AND cgp.effective_start_date BETWEEN eligy_prfl.effective_start_date(+) AND eligy_prfl.effective_end_date(+)

View Text - HTML Formatted

SELECT CGP.ROWID ROW_ID
, CGP.CNTNG_PRTN_ELIG_PRFL_ID
, CGP.EFFECTIVE_START_DATE
, CGP.EFFECTIVE_END_DATE
, ELIGY_PRFL.NAME
, CGP.NAME
, PYMT_MUST_BE_RCVD.MEANING
, CGP.PYMT_MUST_BE_RCVD_NUM
, PYMT_MUST_BE_RCVD2.FORMULA_NAME
, CGP.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_CNTNG_PRTN_ELIG_PRFL_F CGP
, FND_USER FUSER
, BEN_ELIGY_PRFL_F ELIGY_PRFL
, HR_LOOKUPS PYMT_MUST_BE_RCVD
, FF_FORMULAS_F PYMT_MUST_BE_RCVD2
WHERE FUSER.USER_ID(+) = CGP.LAST_UPDATED_BY
AND ELIGY_PRFL.ELIGY_PRFL_ID(+) = CGP.ELIGY_PRFL_ID
AND PYMT_MUST_BE_RCVD.LOOKUP_CODE(+) = CGP.PYMT_MUST_BE_RCVD_UOM
AND PYMT_MUST_BE_RCVD.LOOKUP_TYPE(+) = 'BEN_PYMT_MUST_BE_RECD'
AND PYMT_MUST_BE_RCVD2.FORMULA_ID(+) = CGP.PYMT_MUST_BE_RCVD_RL
AND CGP.EFFECTIVE_START_DATE BETWEEN PYMT_MUST_BE_RCVD2.EFFECTIVE_START_DATE(+)
AND PYMT_MUST_BE_RCVD2.EFFECTIVE_END_DATE(+)
AND CGP.EFFECTIVE_START_DATE BETWEEN ELIGY_PRFL.EFFECTIVE_START_DATE(+)
AND ELIGY_PRFL.EFFECTIVE_END_DATE(+)