APPS.PER_PER_SHD dependencies on PER_ALL_PEOPLE_F

Line 248: from per_all_people_f

244: npw_number,
245: current_npw_flag,
246: global_name,
247: local_name
248: from per_all_people_f
249: where person_id = p_person_id
250: and p_effective_date
251: between effective_start_date and effective_end_date;
252: --

Line 333: p_base_table_name => 'per_all_people_f',

329: -- Call the corresponding datetrack api
330: --
331: dt_api.find_dt_del_modes
332: (p_effective_date => p_effective_date,
333: p_base_table_name => 'per_all_people_f',
334: p_base_key_column => 'person_id',
335: p_base_key_value => p_base_key_value,
336: p_zap => p_zap,
337: p_delete => p_delete,

Line 364: p_base_table_name => 'per_all_people_f',

360: -- Call the corresponding datetrack api
361: --
362: dt_api.find_dt_upd_modes
363: (p_effective_date => p_effective_date,
364: p_base_table_name => 'per_all_people_f',
365: p_base_key_column => 'person_id',
366: p_base_key_value => p_base_key_value,
367: p_correction => p_correction,
368: p_update => p_update,

Line 397: (p_base_table_name => 'per_all_people_f',

393: -- version number.
394: --
395: l_object_version_number :=
396: dt_api.get_object_version_number
397: (p_base_table_name => 'per_all_people_f',
398: p_base_key_column => 'person_id',
399: p_base_key_value => p_base_key_value);
400: --
401: hr_utility.set_location(l_proc, 10);

Line 407: update per_all_people_f t

403: --
404: -- Update the specified datetrack row setting the effective
405: -- end date to the specified new effective end date.
406: --
407: update per_all_people_f t
408: set t.effective_end_date = p_new_effective_end_date,
409: t.object_version_number = l_object_version_number
410: where t.person_id = p_base_key_value
411: and p_effective_date