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 615: FROM PER_ADDRESSES PA, PER_CONTACT_RELATIONSHIPS PCR

611: , PA.PARTY_ID
612: , DERIVED_LOCALE
613: , GEOMETRY
614: , PA.COMMENTS
615: FROM PER_ADDRESSES PA, PER_CONTACT_RELATIONSHIPS PCR
616: WHERE PCR.PERSON_ID = p_person_id
617: AND PCR.CONTACT_PERSON_ID = PA.PERSON_ID
618: and p_eff_date between PCR.DATE_START and nvl(PCR.date_end,to_date('31/12/4712','DD/MM/YYYY'))
619: and p_eff_date between pa.date_from and nvl(pa.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line 687: FROM PER_ADDRESSES PA

683: , PARTY_ID
684: , DERIVED_LOCALE
685: , GEOMETRY
686: , COMMENTS
687: FROM PER_ADDRESSES PA
688: WHERE PA.PERSON_ID = p_person_id
689: and p_eff_date between pa.date_from and nvl(pa.date_to,to_date('31/12/4712','DD/MM/YYYY'));
690:
691: -- cursor to fetch the person extra information record

Line 2496: ,per_addresses pa

2492:
2493: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
2494: from per_people_f ppf
2495: ,per_person_types ppt
2496: ,per_addresses pa
2497: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
2498: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
2499: and pa.person_id = ppf.person_id
2500: and pa.address_id = p_srch_criteria(i).p_address_id;