SELECT ctpd.ptip_id ID, ptp.NAME VALUE, hr_general.start_of_time START_DATE, hr_general.end_of_time END_DATE, ctpd.ptip_ordr_num ORDER_BY, ctpd.pgm_id, ctpd.pl_typ_id FROM hri_cs_co_pgmh_ptip_ct ctpd, ben_pl_typ_f ptp WHERE ctpd.pl_typ_id = ptp.pl_typ_id AND TRUNC(SYSDATE) BETWEEN ptp.effective_start_date AND ptp.effective_end_date
SELECT CTPD.PTIP_ID ID
, PTP.NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, CTPD.PTIP_ORDR_NUM ORDER_BY
, CTPD.PGM_ID
, CTPD.PL_TYP_ID
FROM HRI_CS_CO_PGMH_PTIP_CT CTPD
, BEN_PL_TYP_F PTP
WHERE CTPD.PL_TYP_ID = PTP.PL_TYP_ID
AND TRUNC(SYSDATE) BETWEEN PTP.EFFECTIVE_START_DATE
AND PTP.EFFECTIVE_END_DATE
|
|
|