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.OTA_UTILITY dependencies on PER_PERSON_TYPES

Line 2628: per_person_types ppt

2624: cursor get_person_type is
2625: SELECT ppt.system_person_type
2626: FROM per_all_people_f per,
2627: per_person_type_usages_f ptu,
2628: per_person_types ppt
2629: WHERE
2630: per.person_id = p_person_id
2631: AND ptu.person_id = per.person_id
2632: AND ppt.business_group_id = per.business_group_id

Line 2639: l_system_person_type per_person_types.system_person_type%TYPE;

2635: AND trunc(sysdate) between ptu.effective_start_date AND ptu.effective_end_date
2636: AND ppt.system_person_type <> 'APL'
2637: AND ppt.system_person_type in ('EMP','CWK');
2638:
2639: l_system_person_type per_person_types.system_person_type%TYPE;
2640:
2641: Begin
2642: Open get_person_type;
2643: Fetch get_person_type into l_system_person_type;