DBA Data[Home] [Help]

APPS.SSP_APAB_PKG dependencies on PER_ALL_PEOPLE_F

Line 66: per_all_people_f PERSON,

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

Line 695: from per_all_people_f ppf

691: l_proc varchar2 (72) := g_package||'check_death';
692: --
693: cursor csr_check_death is
694: select ppf.date_of_death
695: from per_all_people_f ppf
696: where ppf.person_id = person.person_id
697: and ppf.date_of_death is not null;
698: --
699: l_death_date date;