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

Line 4651: per_contact_relationships ctr

4647:
4648: select ppf.national_identifier
4649: into l_con_national_identifier
4650: from per_people_f ppf,
4651: per_contact_relationships ctr
4652: where ctr.person_id = ppf.person_id
4653: and ctr.contact_person_id = l_person_id
4654: /* and ctr.personal_flag = 'Y'*/
4655: and ctr.contact_type = 'S'

Line 4660: from per_contact_relationships ctr1

4656: and l_date_earned between ppf.effective_start_date
4657: and ppf.effective_end_date
4658: and ctr.date_start =
4659: (select max(ctr1.date_start)
4660: from per_contact_relationships ctr1
4661: where ctr1.person_id = l_person_id
4662: and ctr1.date_start <= l_year_end
4663: and nvl(ctr1.date_end,
4664: fnd_date.canonical_to_date('4712/12/31 00:00:00'))