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 734: from per_contact_relationships

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

Line 874: from per_contact_relationships pcr1

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

Line 876: from per_contact_relationships pcr2

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

Line 885: , per_contact_relationships pcr

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