APPS.PER_ASG_BUS1 dependencies on PER_PEOPLE_F

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: --

Line 4626: from per_people_f per,

4622: l_system_person_type per_person_types.system_person_type%TYPE;
4623: --
4624: cursor csr_get_sys_per_typ is
4625: select pet.system_person_type
4626: from per_people_f per,
4627: per_person_types pet
4628: where per.person_id = p_person_id
4629: and per.person_type_id = pet.person_type_id
4630: and p_validation_start_date