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

Line 2388: from per_contact_relationships

2384: ,p_type in varchar2) is
2385: --
2386: cursor csr_get_contacts(c_person_id number) is
2387: select contact_person_id, min(nvl(date_start,hr_api.g_sot)) date_start
2388: from per_contact_relationships
2389: where person_id = c_person_id
2390: group by contact_person_id;
2391: --
2392: cursor csr_get_person(c_contact_person_id number) is

Line 2394: from per_contact_relationships ctr

2390: group by contact_person_id;
2391: --
2392: cursor csr_get_person(c_contact_person_id number) is
2393: select ctr.person_id, min(nvl(ctr.date_start,hr_api.g_sot)) date_start
2394: from per_contact_relationships ctr
2395: ,per_person_type_usages_f ptu
2396: ,per_person_types ppt
2397: where ctr.contact_person_id = c_contact_person_id
2398: and ctr.person_id = ptu.person_id