84: service.date_start,
85: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
86: from
87: ssp_maternities MATERNITY,
88: per_all_people_f PERSON,
89: per_periods_of_service SERVICE
90: where
91: person.person_id = maternity.person_id
92: and person.person_id = service.person_id
596: l_proc varchar2 (72) := g_package||'check_death';
597: --
598: cursor csr_check_death is
599: select ppf.date_of_death
600: from per_all_people_f ppf
601: where ppf.person_id = person.person_id
602: and ppf.date_of_death is not null;
603: --
604: cursor csr_get_week_date is