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 7911: ,per_contact_relationships pcr

7907: ,pcr.cont_information2
7908: ,pcr.date_start
7909: ,pcr.date_end
7910: FROM per_all_people_f pap
7911: ,per_contact_relationships pcr
7912: WHERE pap.person_id = pcr.contact_person_id
7913: AND pcr.person_id = personid
7914: AND pcr.contact_type = contacttype
7915: AND (pcr.date_start is null or pcr.date_start <= abs_stdt)