DBA Data[Home] [Help]

APPS.SSP_SMP_PKG dependencies on PER_ALL_PEOPLE_F

Line 162: to per_all_people_f and per_all_assignments_f

158: 16-JUN-2006 ajeyam 115.29 5210118 In check_continuity_rule procedure,
159: period_of_service cursor changed to fetch the
160: latest start date for rehired persons.
161: 23-AUG-2006 kthampan 115.30 5482199 Change from per_people_f and per_assignments_f
162: to per_all_people_f and per_all_assignments_f
163: 19-SEP-2006 kthampan 115.31 5547703 Amend smp_control to call generate_payments
164: with insert-mode if absence is > 0 and
165: also change csr_check_if_existing_entries
166: not to reference from per_absence_attendances

Line 214: per_all_people_f PERSON,

210: service.date_start,
211: nvl (service.final_process_date, hr_general.end_of_time)
212: FINAL_PROCESS_DATE
213: from ssp_maternities MATERNITY,
214: per_all_people_f PERSON,
215: per_periods_of_service SERVICE
216: where person.person_id = maternity.person_id
217: and person.person_id = service.person_id
218: and maternity.maternity_id = p_maternity_id