APPS.SSP_APAD_PKG dependencies on PER_ALL_PEOPLE_F

Line 67: per_all_people_f PERSON,

63: person.date_of_death,
64: service.date_start,
65: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
66: from ssp_maternities MATERNITY,
67: per_all_people_f PERSON,
68: per_periods_of_service SERVICE
69: where person.person_id = maternity.person_id
70: and person.person_id = service.person_id
71: and maternity.maternity_id = p_maternity_id

Line 653: from per_all_people_f ppf

649: l_proc varchar2 (72) := g_package||'check_death';
650: --
651: cursor csr_check_death is
652: select ppf.date_of_death
653: from per_all_people_f ppf
654: where ppf.person_id = person.person_id
655: and ppf.date_of_death is not null;
656:
657: l_death_date date;