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

Line 354: ,per_contact_relationships pcr

350: ,pcr.cont_information1
351: ,pcr.cont_information2
352: ,nvl(pcr.date_end,to_date('31-12-4712','DD-MM-YYYY')) date_end
353: FROM per_all_people_f pap
354: ,per_contact_relationships pcr
355: WHERE pap.person_id = pcr.contact_person_id
356: AND pcr.person_id = p_person_id
357: AND pcr.contact_type = p_contact_type
358: AND (pcr.date_start is null or pcr.date_start <= p_eff_date)

Line 549: ,per_contact_relationships pcr

545: ,pcr.cont_information2
546: ,NVL(pcr.date_end,TO_DATE('31-12-4712','DD-MM-YYYY')) date_end
547: ,pcr.contact_relationship_id
548: FROM per_all_people_f pap
549: ,per_contact_relationships pcr
550: WHERE pap.person_id = pcr.contact_person_id
551: AND pcr.person_id = personid
552: AND pcr.contact_type = contacttype
553: AND (pcr.date_start IS NULL OR pcr.date_start <= abs_stdt)