VIEW: APPS.HRI_CL_EDU_QUAL_AWRDBDY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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