[Home] [Help]
648: WHEN perf.event_id IS NULL THEN
649: NULL
650: WHEN perf.event_id IS NOT NULL THEN
651: (SELECT appraisal_id
652: FROM per_appraisals
653: WHERE appraisee_person_id = ppf.person_id
654: AND event_id = perf.event_id)
655: END ) appraisal_id
656: from per_all_people_f ppf