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

Line 1258: per_person_types ppt

1254: -- VT 1403481 09/19/00
1255: select count(*)
1256: into v_person_types
1257: from per_people_f p,
1258: per_person_types ppt
1259: where p.person_id = P_PERSON_ID
1260: and p.effective_end_date >= P_SESSION_DATE
1261: and p.person_type_id = ppt.person_type_id
1262: and exists

Line 1265: per_person_types ppt2

1261: and p.person_type_id = ppt.person_type_id
1262: and exists
1263: (select null
1264: from per_people_f p2,
1265: per_person_types ppt2
1266: where p2.person_id = p.person_id
1267: and p2.effective_end_date >= P_SESSION_DATE
1268: and p2.person_type_id = ppt2.person_type_id
1269: and ppt2.system_person_type <> ppt.system_person_type