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 4711: from per_contact_relationships

4707: ,p_type in varchar2) is
4708: --
4709: cursor csr_get_contacts(c_person_id number) is
4710: select contact_person_id, min(nvl(date_start,hr_api.g_sot)) date_start
4711: from per_contact_relationships
4712: where person_id = c_person_id
4713: group by contact_person_id;
4714: --
4715: cursor csr_get_person(c_contact_person_id number) is

Line 4717: from per_contact_relationships ctr

4713: group by contact_person_id;
4714: --
4715: cursor csr_get_person(c_contact_person_id number) is
4716: select ctr.person_id, min(nvl(ctr.date_start,hr_api.g_sot)) date_start
4717: from per_contact_relationships ctr
4718: ,per_person_type_usages_f ptu
4719: ,per_person_types ppt
4720: where ctr.contact_person_id = c_contact_person_id
4721: and ctr.person_id = ptu.person_id