DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on PER_ALL_PEOPLE_F

Line 684: (p_base_table_name => 'per_all_people_f',

680: -- End of fix 2535030
681:
682: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
683: NOT (dt_api.check_min_max_dates
684: (p_base_table_name => 'per_all_people_f',
685: p_base_key_column => 'person_id',
686: p_base_key_value => p_person_id,
687: p_from_date => p_validation_start_date,
688: p_to_date => p_validation_end_date))) Then

Line 3489: from per_all_people_f --#3663845 per_people_f

3485: l_worker_number varchar2(30);
3486: --
3487: cursor csr_get_work_no is
3488: select decode(p_assignment_type,'E',employee_number,'C',npw_number)
3489: from per_all_people_f --#3663845 per_people_f
3490: where person_id = p_person_id
3491: and p_effective_date between effective_start_date
3492: and effective_end_date;
3493: --