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.HRWSECI dependencies on PER_CONTACT_RELATIONSHIPS

Line 2693: from per_contact_relationships cre

2689: l_dummy varchar2(1);
2690: --
2691: cursor c1 is
2692: select null
2693: from per_contact_relationships cre
2694: where cre.contact_relationship_id = p_contact_relationship_id;
2695: --
2696: Begin
2697: --

Line 2709: -- Make sure that contact exists in PER_CONTACT_RELATIONSHIPS table

2705: hr_utility.raise_error;
2706: --
2707: end if;
2708: --
2709: -- Make sure that contact exists in PER_CONTACT_RELATIONSHIPS table
2710: --
2711: open c1;
2712: --
2713: fetch c1 into l_dummy;

Line 3161: per_contact_relationships b

3157: --
3158: cursor c1 is
3159: select a.date_of_birth
3160: from per_people_f a,
3161: per_contact_relationships b
3162: where a.person_id = b.contact_person_id
3163: and b.contact_relationship_id = p_contact_relationship_id;
3164: --
3165: l_dob date;