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_PERSON_INFORMATION dependencies on PER_PERSON_TYPES

Line 143: ,per_person_types ppt

139: ,substr(ppt.user_person_type,1,15) u_p_t
140: ,substr(ppt.system_person_type,1,7) p_t_id
141: ,ppf.party_id p_id
142: from per_people_f ppf
143: ,per_person_types ppt
144: where ppf.person_id = p_person_id
145: and ppf.person_type_id = ppt.person_type_id
146: order by ppf.effective_start_date
147: ,ppf.effective_end_date;

Line 173: ,per_person_types ppt

169: ,SUBSTR(ppt.user_person_type,1,20) u_p_t
170: ,SUBSTR(ppt.system_person_type,1,7) p_t_id
171: ,ptu.person_type_id p_id
172: FROM per_person_type_usages_f ptu
173: ,per_person_types ppt
174: WHERE ptu.person_id = p_person_id
175: AND ptu.person_type_id = ppt.person_type_id
176: ORDER BY ptu_id, e_s_d;
177: