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

Line 124: ,per_person_type_usages_f ptu

120: ,ttl.user_person_type
121: ,NULL ) OTHER_PERSON_TYPE
122: FROM per_person_types_tl ttl
123: ,per_person_types typ
124: ,per_person_type_usages_f ptu
125: WHERE ttl.language = userenv('LANG')
126: AND ttl.person_type_id = typ.person_type_id
127: AND typ.system_person_type IN ('APL','EMP','EX_APL','EX_EMP','CWK','EX_CWK','OTHER')
128: AND typ.person_type_id = ptu.person_type_id

Line 321: ,per_person_type_usages_f ptu

317: SELECT
318: ppt.system_person_type
319: FROM
320: per_person_types ppt
321: ,per_person_type_usages_f ptu
322: WHERE ptu.person_id = p_person_id
323: AND p_effective_date
324: BETWEEN ptu.effective_start_date AND ptu.effective_end_date
325: AND ptu.person_type_id = ppt.person_type_id