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

Line 735: from per_contact_relationships

731: -- existing for a contact. ( Ref Bug # 622399 )
732:
733: CURSOR csr_count_relationships IS
734: select count(*)
735: from per_contact_relationships
736: where (contact_person_id = p_person_id
737: or person_id = p_person_id);
738:
739: l_exists varchar2(1);

Line 876: from per_contact_relationships pcr1

872: --
873: Cursor get_mirror is
874: select pcr1.contact_relationship_id
875: , pcr1.contact_person_id
876: from per_contact_relationships pcr1
877: where exists (select 1
878: from per_contact_relationships pcr2
879: where contact_relationship_id = p_contact_relationship_id
880: and pcr1.contact_person_id = pcr2.person_id

Line 878: from per_contact_relationships pcr2

874: select pcr1.contact_relationship_id
875: , pcr1.contact_person_id
876: from per_contact_relationships pcr1
877: where exists (select 1
878: from per_contact_relationships pcr2
879: where contact_relationship_id = p_contact_relationship_id
880: and pcr1.contact_person_id = pcr2.person_id
881: );
882: --

Line 887: , per_contact_relationships pcr

883: Cursor check_garnishor(l_contact_id NUMBER,l_contact_relationship_id NUMBER)
884: is select '1'
885: from pay_personal_payment_methods_f ppm
886: , per_assignments_f paf
887: , per_contact_relationships pcr
888: , fnd_sessions f
889: where ppm.payee_type = 'P'
890: and ppm.payee_id = l_contact_id
891: and ppm.assignment_id = paf.assignment_id