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

Line 74: from per_person_types ppt, per_person_type_usages_f pptu

70: and a.assignment_type in ('E', 'C')
71: and a.person_id = p.person_id
72:
73: and exists (select ppt.system_person_type
74: from per_person_types ppt, per_person_type_usages_f pptu
75: where pptu.person_id = p.person_id
76: and ppt.person_type_id = pptu.person_type_id
77: and ppt.system_person_type in ('EMP','CWK')
78: and X_session_date between pptu.effective_start_date

Line 112: from per_person_types ppt, per_person_type_usages_f ptu

108: and a.assignment_type in ('E', 'C')
109: and a.person_id = p.person_id
110: and exists
111: (select ppt.system_person_type
112: from per_person_types ppt, per_person_type_usages_f ptu
113: where ptu.person_id = p.person_id
114: and ppt.person_type_id = ptu.person_type_id
115: and ppt.system_person_type in ('EMP', 'CWK')
116: and X_session_date between ptu.effective_start_date and ptu.effective_end_date)