APPS.PER_PTU_BUS dependencies on PER_ALL_PEOPLE_F

Line 79: (p_base_table_name => 'per_all_people_f', -- Bug 3111207

75: p_argument_value => p_validation_end_date);
76: --
77: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
78: NOT (dt_api.check_min_max_dates
79: (p_base_table_name => 'per_all_people_f', -- Bug 3111207
80: p_base_key_column => 'person_id',
81: p_base_key_value => p_person_id,
82: p_from_date => p_validation_start_date,
83: p_to_date => p_validation_end_date))) Then

Line 453: -- the parent PER_ALL_PEOPLE_F table.

449: -- -----------------------------------------------------------------
450: --
451: -- Description:
452: -- Check that the person_id is not null and that it refers to a row on
453: -- the parent PER_ALL_PEOPLE_F table.
454: --
455: -- Pre-Requisites:
456: -- None
457: --

Line 482: from per_all_people_f

478:
479: -- Setup cursor for valid module type check
480: cursor csr_valid_person_id is
481: select person_id
482: from per_all_people_f
483: where person_id = p_person_id;
484: --
485: begin
486: hr_utility.set_location('Entering: '||l_proc,5);

Line 830: , per_all_people_f per

826: cursor csr_leg_code is
827: select pbg.legislation_code
828: from per_business_groups pbg
829: , per_person_type_usages_f ptu
830: , per_all_people_f per
831: where ptu.person_type_usage_id = p_person_type_usage_id
832: and ptu.person_id = per.person_id
833: and pbg.business_group_id = per.business_group_id;
834: --