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.ARI_SELF_REGISTRATION_PKG dependencies on HZ_RELATIONSHIPS

Line 970: from hz_relationships hr1,

966:
967: select party_id into l_party_rel_id
968: from (
969: select hr1.party_id
970: from hz_relationships hr1,
971: hz_relationships hr2,
972: fnd_user fu
973: where hr1.subject_type = 'PERSON'
974: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')

Line 971: hz_relationships hr2,

967: select party_id into l_party_rel_id
968: from (
969: select hr1.party_id
970: from hz_relationships hr1,
971: hz_relationships hr2,
972: fnd_user fu
973: where hr1.subject_type = 'PERSON'
974: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')
975: AND hr1.status = 'A'

Line 984: from hz_relationships hr1,

980: and fu.user_id = p_user_id
981: UNION ALL
982: select hr1.party_id
983:
984: from hz_relationships hr1,
985: fnd_user fu, hz_parties Party
986: where hr1.subject_type = 'PERSON'
987: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')
988: AND hr1.status = 'A'

Line 1431: FROM HZ_RELATIONSHIPS

1427: BEGIN
1428: --Bug 4764121: Storing the value of party_id (even when relationship exists)
1429: SELECT 'Y',party_id
1430: INTO l_already_exists,p_party_id
1431: FROM HZ_RELATIONSHIPS
1432: WHERE SUBJECT_ID = p_person_party_id
1433: AND SUBJECT_TYPE = 'PERSON'
1434: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1435: AND RELATIONSHIP_TYPE = 'CONTACT'