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_API dependencies on PER_CONTACT_RELATIONSHIPS

Line 2804: and not exists (select null from per_contact_relationships pcr where pcr.contact_person_id = ptuf.person_id)

2800: where ppt.system_person_type = 'IRC_REG_USER'
2801: and ptuf.person_type_id = ppt.person_type_id
2802: and ppt.business_group_id + 0 = nvl(l_bg_id,ppt.business_group_id)
2803: and not exists (select null from per_all_assignments_f paaf where paaf.person_id = ptuf.person_id)
2804: and not exists (select null from per_contact_relationships pcr where pcr.contact_person_id = ptuf.person_id)
2805: and ptuf.person_id=p_source_person_id;
2806: EXCEPTION
2807: WHEN OTHERS THEN
2808: NULL;

Line 3217: and not exists (select null from per_contact_relationships pcr where pcr.contact_person_id = ptuf.person_id)

3213: where ppt.system_person_type = 'IRC_REG_USER'
3214: and ptuf.person_type_id = ppt.person_type_id
3215: and ppt.business_group_id + 0 = nvl(l_bg_id,ppt.business_group_id)
3216: and not exists (select null from per_all_assignments_f paaf where paaf.person_id = ptuf.person_id)
3217: and not exists (select null from per_contact_relationships pcr where pcr.contact_person_id = ptuf.person_id)
3218: and ptuf.person_id=p_target_person_id;
3219: EXCEPTION
3220: WHEN OTHERS THEN
3221: NULL;