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.HR_PERSON_RECORD dependencies on PER_ADDRESSES

Line 634: FROM PER_ADDRESSES PA, PER_CONTACT_RELATIONSHIPS PCR

630: , PA.PARTY_ID
631: , DERIVED_LOCALE
632: , GEOMETRY
633: , PA.COMMENTS
634: FROM PER_ADDRESSES PA, PER_CONTACT_RELATIONSHIPS PCR
635: WHERE PCR.PERSON_ID = p_person_id
636: AND PCR.CONTACT_PERSON_ID = PA.PERSON_ID
637: and p_eff_date between PCR.DATE_START and nvl(PCR.date_end,to_date('31/12/4712','DD/MM/YYYY'))
638: and p_eff_date between pa.date_from and nvl(pa.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line 706: FROM PER_ADDRESSES PA

702: , PARTY_ID
703: , DERIVED_LOCALE
704: , GEOMETRY
705: , COMMENTS
706: FROM PER_ADDRESSES PA
707: WHERE PA.PERSON_ID = p_person_id
708: and p_eff_date between pa.date_from and nvl(pa.date_to,to_date('31/12/4712','DD/MM/YYYY'));
709:
710: -- cursor to fetch the person extra information record

Line 1655: ,per_addresses pa

1651:
1652: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
1653: from per_people_f ppf
1654: ,per_person_types ppt
1655: ,per_addresses pa
1656: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
1657: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
1658: and pa.person_id = ppf.person_id
1659: and pa.address_id = p_srch_criteria(i).p_address_id;