VIEW: APPS.HRI_CL_CO_PGM_V

Source

View Text - Preformatted

SELECT pgm.pgm_id ID, pgm.NAME VALUE, pgm.effective_start_date start_date, pgm.effective_end_date end_date FROM hri_cs_co_pgm_ct pgmd, ben_pgm_f pgm WHERE pgmd.pgm_id = pgm.pgm_id

View Text - HTML Formatted

SELECT PGM.PGM_ID ID
, PGM.NAME VALUE
, PGM.EFFECTIVE_START_DATE START_DATE
, PGM.EFFECTIVE_END_DATE END_DATE
FROM HRI_CS_CO_PGM_CT PGMD
, BEN_PGM_F PGM
WHERE PGMD.PGM_ID = PGM.PGM_ID