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_NO_ABSENCE dependencies on PER_CONTACT_RELATIONSHIPS

Line 170: ,per_contact_relationships pcr

166: ,pcr.contact_type
167: ,pcr.cont_information1
168: ,pcr.cont_information2
169: FROM per_all_people_f pap
170: ,per_contact_relationships pcr
171: WHERE pap.person_id = pcr.contact_person_id
172: AND pcr.person_id = personid
173: AND pcr.contact_type = contacttype
174: AND (pcr.date_start is null or pcr.date_start <= abs_stdt)

Line 7806: ,per_contact_relationships pcr

7802: ,pcr.cont_information2
7803: ,pcr.date_start
7804: ,pcr.date_end
7805: FROM per_all_people_f pap
7806: ,per_contact_relationships pcr
7807: WHERE pap.person_id = pcr.contact_person_id
7808: AND pcr.person_id = personid
7809: AND pcr.contact_type = contacttype
7810: AND (pcr.date_start is null or pcr.date_start <= abs_stdt)