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
657: ,per_all_assignments_f paf
658: ,ben_per_in_ler pil
659: ,per_all_people_f supv
660: ,per_all_assignments_f supv_asg
655: END ) appraisal_id
656: from per_all_people_f ppf
657: ,per_all_assignments_f paf
658: ,ben_per_in_ler pil
659: ,per_all_people_f supv
660: ,per_all_assignments_f supv_asg
661: ,hr_organization_information bg
662: ,hr_organization_information supv_bg
663: ,per_periods_of_service service_period