DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on PER_ALL_PEOPLE_F

Line 757: (p_base_table_name => 'per_all_people_f',

753: -- End of fix 2535030
754:
755: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
756: NOT (dt_api.check_min_max_dates
757: (p_base_table_name => 'per_all_people_f',
758: p_base_key_column => 'person_id',
759: p_base_key_value => p_person_id,
760: p_from_date => p_validation_start_date,
761: p_to_date => p_validation_end_date))) Then

Line 3611: from per_all_people_f --#3663845 per_people_f

3607: l_worker_number varchar2(30);
3608: --
3609: cursor csr_get_work_no is
3610: select decode(p_assignment_type,'E',employee_number,'C',npw_number)
3611: from per_all_people_f --#3663845 per_people_f
3612: where person_id = p_person_id
3613: and p_effective_date between effective_start_date
3614: and effective_end_date;
3615: --