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 936: from hz_relationships hr1,

932:
933: select party_id into l_party_rel_id
934: from (
935: select hr1.party_id
936: from hz_relationships hr1,
937: hz_relationships hr2,
938: fnd_user fu
939: where hr1.subject_type = 'PERSON'
940: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')

Line 937: hz_relationships hr2,

933: select party_id into l_party_rel_id
934: from (
935: select hr1.party_id
936: from hz_relationships hr1,
937: hz_relationships hr2,
938: fnd_user fu
939: where hr1.subject_type = 'PERSON'
940: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')
941: AND hr1.status = 'A'

Line 950: from hz_relationships hr1,

946: and fu.user_id = p_user_id
947: UNION ALL
948: select hr1.party_id
949:
950: from hz_relationships hr1,
951: fnd_user fu, hz_parties Party
952: where hr1.subject_type = 'PERSON'
953: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')
954: AND hr1.status = 'A'

Line 1337: FROM HZ_RELATIONSHIPS

1333: BEGIN
1334: --Bug 4764121: Storing the value of party_id (even when relationship exists)
1335: SELECT 'Y',party_id
1336: INTO l_already_exists,p_party_id
1337: FROM HZ_RELATIONSHIPS
1338: WHERE SUBJECT_ID = p_person_party_id
1339: AND SUBJECT_TYPE = 'PERSON'
1340: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1341: AND RELATIONSHIP_TYPE = 'CONTACT'