eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ASG_BUS1 dependencies on PER_PEOPLE_F

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

Line 4752: from per_people_f per,

4748: l_system_person_type per_person_types.system_person_type%TYPE;
4749: --
4750: cursor csr_get_sys_per_typ is
4751: select pet.system_person_type
4752: from per_people_f per,
4753: per_person_types pet
4754: where per.person_id = p_person_id
4755: and per.person_type_id = pet.person_type_id
4756: and p_validation_start_date