VIEW: APPS.HRI_CL_CO_PGMH_OIPLIP_V

Source

View Text - Preformatted

SELECT copd.compobj_sk_pk ID, opt.NAME VALUE, hr_general.start_of_time start_date, hr_general.end_of_time end_date, pln.name pl_value , copd.oipl_ordr_num ORDER_BY , copd.pgm_id , copd.pl_typ_id , copd.pl_id , copd.opt_id , copd.ptip_id , copd.plip_id , copd.oiplip_id FROM hri_cs_compobj_ct copd , ben_opt_f opt , ben_pl_f pln WHERE copd.pl_id = pln.pl_id AND copd.opt_id = opt.opt_id (+) AND TRUNC(SYSDATE) BETWEEN opt.effective_start_date(+) AND opt.effective_end_date(+) AND TRUNC(SYSDATE) BETWEEN pln.effective_start_date AND pln.effective_end_date

View Text - HTML Formatted

SELECT COPD.COMPOBJ_SK_PK ID
, OPT.NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, PLN.NAME PL_VALUE
, COPD.OIPL_ORDR_NUM ORDER_BY
, COPD.PGM_ID
, COPD.PL_TYP_ID
, COPD.PL_ID
, COPD.OPT_ID
, COPD.PTIP_ID
, COPD.PLIP_ID
, COPD.OIPLIP_ID
FROM HRI_CS_COMPOBJ_CT COPD
, BEN_OPT_F OPT
, BEN_PL_F PLN
WHERE COPD.PL_ID = PLN.PL_ID
AND COPD.OPT_ID = OPT.OPT_ID (+)
AND TRUNC(SYSDATE) BETWEEN OPT.EFFECTIVE_START_DATE(+)
AND OPT.EFFECTIVE_END_DATE(+)
AND TRUNC(SYSDATE) BETWEEN PLN.EFFECTIVE_START_DATE
AND PLN.EFFECTIVE_END_DATE