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 3327: from per_contact_relationships cre

3323: l_dummy varchar2(1);
3324: --
3325: cursor c1 is
3326: select null
3327: from per_contact_relationships cre
3328: where cre.contact_relationship_id = p_contact_relationship_id;
3329: --
3330: Begin
3331: --

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

3339: hr_utility.raise_error;
3340: --
3341: end if;
3342: --
3343: -- Make sure that contact exists in PER_CONTACT_RELATIONSHIPS table
3344: --
3345: open c1;
3346: --
3347: fetch c1 into l_dummy;

Line 3805: per_contact_relationships b

3801: --
3802: cursor c1 is
3803: select a.date_of_birth
3804: from per_people_f a,
3805: per_contact_relationships b
3806: where a.person_id = b.contact_person_id
3807: and b.contact_relationship_id = p_contact_relationship_id;
3808: --
3809: l_dob date;