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_CONTACT_RELATIONSHIPS

Line 559: FROM PER_CONTACT_RELATIONSHIPS PCR

555: , CONT_INFORMATION17
556: , CONT_INFORMATION18
557: , CONT_INFORMATION19
558: , CONT_INFORMATION20
559: FROM PER_CONTACT_RELATIONSHIPS PCR
560: where PCR.PERSON_ID = p_person_id
561: and PCR.business_group_id = p_business_group_id
562: and p_eff_date between DATE_START and nvl(date_end,to_date('31/12/4712','DD/MM/YYYY') );
563:

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 1228: FROM PER_CONTACT_RELATIONSHIPS PCR

1224: , CEI_ATTRIBUTE19
1225: , CEI_ATTRIBUTE20
1226: FROM PER_CONTACT_EXTRA_INFO_F
1227: WHERE CONTACT_RELATIONSHIP_ID in (SELECT PCR.CONTACT_RELATIONSHIP_ID
1228: FROM PER_CONTACT_RELATIONSHIPS PCR
1229: where PCR.PERSON_ID = p_person_id
1230: and PCR.business_group_id = p_business_group_id
1231: and p_eff_date between DATE_START and nvl(date_end,to_date('31/12/4712','DD/MM/YYYY') ));
1232: