VIEW: APPS.HRI_CL_EDU_QUAL_TITLE_V

Source

View Text - Preformatted

SELECT qal.title ID ,qal.title VALUE FROM per_qualifications qal WHERE qal.title IS NOT NULL UNION ALL SELECT '' ID ,'' VALUE FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT QAL.TITLE ID
, QAL.TITLE VALUE
FROM PER_QUALIFICATIONS QAL
WHERE QAL.TITLE IS NOT NULL UNION ALL SELECT '' ID
, '' VALUE
FROM DUAL WITH READ ONLY