VIEW: APPS.HRI_CL_EDU_EST_CAND_V

Source

View Text - Preformatted

SELECT pea.establishment ID ,pea.establishment VALUE FROM per_establishment_attendances pea WHERE pea.establishment IS NOT NULL UNION ALL SELECT '' ID ,'' VALUE FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT PEA.ESTABLISHMENT ID
, PEA.ESTABLISHMENT VALUE
FROM PER_ESTABLISHMENT_ATTENDANCES PEA
WHERE PEA.ESTABLISHMENT IS NOT NULL UNION ALL SELECT '' ID
, '' VALUE
FROM DUAL WITH READ ONLY