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.HR_EMPLOYEE_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 2572: from per_person_type_usages_f ptu,per_person_types ppt

2568: -- Bug 3611984 starts here
2569: l_ptu_datetrack_mode varchar2(12);
2570: cursor c_ptu_start_date is
2571: select effective_start_date
2572: from per_person_type_usages_f ptu,per_person_types ppt
2573: where ptu.person_type_id = ppt.person_type_id
2574: and ptu.person_id = p_person_id
2575: and p_hire_date between ptu.effective_start_date and ptu.effective_end_date
2576: and ppt.system_person_type='EX_EMP';

Line 2634: per_person_type_usages_f ptu

2630: per.effective_start_date,
2631: pet.system_person_type
2632: from per_person_types pet,
2633: per_people_f per,
2634: per_person_type_usages_f ptu
2635: where per.person_id = p_person_id
2636: and pet.person_type_id = ptu.person_type_id
2637: and ptu.person_id = per.person_id
2638: -- added this condition for 5601538