APPS.SSP_PAD_PKG dependencies on PER_ALL_PEOPLE_F

Line 40: to per_all_people_f and per_all_assignments_f

36: one in the cursor csr_existing_entries
37: and twice when calling insert_element_entry
38: 09 Feb 06 kthampan 4891953 Fixed performance bug.
39: 23 Aug 06 Kthampan 5482199 Change from per_people_f and per_assignments_f
40: to per_all_people_f and per_all_assignments_f
41: 19 Sep 06 Kthampan 5547703 Amend pad_control to call generate_payments
42: with insert-mode if absence is > 0 and
43: also change csr_check_if_existing_entries
44: not to reference from per_absence_attendances

Line 91: per_all_people_f PERSON,

87: person.date_of_death,
88: service.date_start,
89: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
90: from ssp_maternities MATERNITY,
91: per_all_people_f PERSON,
92: per_periods_of_service SERVICE
93: where person.person_id = maternity.person_id
94: and person.person_id = service.person_id
95: and maternity.maternity_id = p_maternity_id

Line 622: from per_all_people_f ppf

618: l_proc varchar2 (72) := g_package||'check_death';
619: --
620: cursor csr_check_death is
621: select ppf.date_of_death
622: from per_all_people_f ppf
623: where ppf.person_id = person.person_id
624: and ppf.date_of_death is not null;
625:
626: l_death_date date;