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 334: p_base_table_name => 'per_all_people_f',

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

Line 365: p_base_table_name => 'per_all_people_f',

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

Line 398: (p_base_table_name => 'per_all_people_f',

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

Line 408: update per_all_people_f t

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

Line 595: from per_all_people_f -- for bug 7518991

591: npw_number,
592: current_npw_flag,
593: global_name,
594: local_name
595: from per_all_people_f -- for bug 7518991
596: where person_id = p_person_id
597: and p_effective_date
598: between effective_start_date and effective_end_date
599: for update nowait;

Line 683: p_base_table_name => 'per_all_people_f', -- for bug 7518991

679:
680: dt_api.validate_dt_mode
681: (p_effective_date => p_effective_date,
682: p_datetrack_mode => p_datetrack_mode,
683: p_base_table_name => 'per_all_people_f', -- for bug 7518991
684: p_base_key_column => 'person_id',
685: p_base_key_value => p_person_id,
686: p_child_table_name1 => 'per_contracts_f',
687: p_child_key_column1 => 'contract_id',

Line 719: hr_utility.set_message_token('TABLE_NAME', 'per_all_people_f');

715: -- The object is locked therefore we need to supply a meaningful
716: -- error message.
717: --
718: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
719: hr_utility.set_message_token('TABLE_NAME', 'per_all_people_f');
720: hr_utility.raise_error;
721: When l_object_invalid then
722: --
723: -- The object doesn't exist or is invalid

Line 726: hr_utility.set_message_token('TABLE_NAME', 'per_all_people_f');

722: --
723: -- The object doesn't exist or is invalid
724: --
725: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
726: hr_utility.set_message_token('TABLE_NAME', 'per_all_people_f');
727: hr_utility.raise_error;
728: End lck;
729: --
730: -- ----------------------------------------------------------------------------