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 289: from per_contact_relationships ctr

285: personal_flag,
286: rltd_per_rsds_w_dsgntr_flag,
287: person_id,
288: date_end
289: from per_contact_relationships ctr
290: where ctr.contact_relationship_id = p_contact_relationship_id
291: and c_effective_date >=
292: nvl(date_start,c_effective_date);
293: --

Line 299: from per_contact_relationships ctr

295: --
296: cursor c_contact2 (p_effective_date in date)
297: is
298: select contact_type
299: from per_contact_relationships ctr
300: where ctr.contact_relationship_id <> p_contact_relationship_id
301: and ctr.contact_person_id = p_contact_person_id
302: and ctr.personal_flag = 'Y'
303: and p_effective_date between nvl(ctr.date_start,p_effective_date)

Line 2140: from per_contact_relationships ctr

2136: --
2137: cursor c_contact (p_contact_type in varchar2,
2138: p_effective_date in date) is
2139: select null
2140: from per_contact_relationships ctr
2141: where ctr.contact_type = p_contact_type
2142: and ctr.contact_person_id = p_person_id
2143: and ctr.person_id = p_contact_person_id -- Bug 6956648
2144: and ctr.personal_flag = 'Y'