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 3987: per_contact_relationships ctr

3983:
3984: select ppf.national_identifier
3985: into l_con_national_identifier
3986: from per_people_f ppf,
3987: per_contact_relationships ctr
3988: where ctr.person_id = ppf.person_id
3989: and ctr.contact_person_id = l_person_id
3990: /* and ctr.personal_flag = 'Y'*/
3991: and ctr.contact_type = 'S'

Line 3996: from per_contact_relationships ctr1

3992: and l_date_earned between ppf.effective_start_date
3993: and ppf.effective_end_date
3994: and ctr.date_start =
3995: (select max(ctr1.date_start)
3996: from per_contact_relationships ctr1
3997: where ctr1.person_id = l_person_id
3998: and ctr1.date_start <= l_year_end
3999: and nvl(ctr1.date_end,
4000: fnd_date.canonical_to_date('4712/12/31 00:00:00'))