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

Line 3322: from per_contact_relationships cre

3318: l_dummy varchar2(1);
3319: --
3320: cursor c1 is
3321: select null
3322: from per_contact_relationships cre
3323: where cre.contact_relationship_id = p_contact_relationship_id;
3324: --
3325: Begin
3326: --

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

3334: hr_utility.raise_error;
3335: --
3336: end if;
3337: --
3338: -- Make sure that contact exists in PER_CONTACT_RELATIONSHIPS table
3339: --
3340: open c1;
3341: --
3342: fetch c1 into l_dummy;

Line 3800: per_contact_relationships b

3796: --
3797: cursor c1 is
3798: select a.date_of_birth
3799: from per_people_f a,
3800: per_contact_relationships b
3801: where a.person_id = b.contact_person_id
3802: and b.contact_relationship_id = p_contact_relationship_id;
3803: --
3804: l_dob date;