SELECT cpt.ROWID row_id, cpt.cmbn_ptip_opt_id, cpt.effective_start_date, cpt.effective_end_date, cpt.NAME, cpt.last_update_date, fuser.user_name, pgm.NAME, opt.NAME FROM ben_cmbn_ptip_opt_f cpt, fnd_user fuser, ben_pgm_f pgm, ben_opt_f opt WHERE fuser.user_id(+) = cpt.last_updated_by AND cpt.pgm_id = pgm.pgm_id(+) AND opt.opt_id(+) = cpt.opt_id AND cpt.effective_start_date BETWEEN pgm.effective_start_date(+) AND pgm.effective_end_date(+) AND cpt.effective_start_date BETWEEN opt.effective_start_date(+) AND opt.effective_end_date(+)
SELECT CPT.ROWID ROW_ID
, CPT.CMBN_PTIP_OPT_ID
, CPT.EFFECTIVE_START_DATE
, CPT.EFFECTIVE_END_DATE
, CPT.NAME
, CPT.LAST_UPDATE_DATE
, FUSER.USER_NAME
, PGM.NAME
, OPT.NAME
FROM BEN_CMBN_PTIP_OPT_F CPT
, FND_USER FUSER
, BEN_PGM_F PGM
, BEN_OPT_F OPT
WHERE FUSER.USER_ID(+) = CPT.LAST_UPDATED_BY
AND CPT.PGM_ID = PGM.PGM_ID(+)
AND OPT.OPT_ID(+) = CPT.OPT_ID
AND CPT.EFFECTIVE_START_DATE BETWEEN PGM.EFFECTIVE_START_DATE(+)
AND PGM.EFFECTIVE_END_DATE(+)
AND CPT.EFFECTIVE_START_DATE BETWEEN OPT.EFFECTIVE_START_DATE(+)
AND OPT.EFFECTIVE_END_DATE(+)
|
|
|