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

Line 296: from per_contact_relationships ctr

292: personal_flag,
293: rltd_per_rsds_w_dsgntr_flag,
294: person_id,
295: date_end
296: from per_contact_relationships ctr
297: where ctr.contact_relationship_id = p_contact_relationship_id
298: and c_effective_date >=
299: nvl(date_start,c_effective_date);
300: --

Line 306: from per_contact_relationships ctr

302: --
303: cursor c_contact2 (p_effective_date in date)
304: is
305: select contact_type
306: from per_contact_relationships ctr
307: where ctr.contact_relationship_id <> p_contact_relationship_id
308: and ctr.contact_person_id = p_contact_person_id
309: and ctr.personal_flag = 'Y'
310: and p_effective_date between nvl(ctr.date_start,p_effective_date)

Line 2173: from per_contact_relationships ctr

2169: --
2170: cursor c_contact (p_contact_type in varchar2,
2171: p_effective_date in date) is
2172: select null
2173: from per_contact_relationships ctr
2174: where ctr.contact_type = p_contact_type
2175: and ctr.contact_person_id = p_person_id
2176: and ctr.person_id = p_contact_person_id -- Bug 6956648
2177: and ctr.personal_flag = 'Y'