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

Line 1138: from hz_relationships

1134: ,x_valid_flag OUT NOCOPY VARCHAR2) is
1135:
1136: cursor org_contact_exist_csr is
1137: select 'x'
1138: from hz_relationships
1139: where subject_id = p_person_party_id
1140: and object_id = p_security_id
1141: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1142: AND OBJECT_TABLE_NAME = 'HZ_PARTIES';

Line 1147: hz_relationships rel

1143:
1144: cursor opp_contact_exist_csr is
1145: select 'x'
1146: from as_lead_contacts cont,
1147: hz_relationships rel
1148: where cont.contact_party_id = rel.party_id
1149: and rel.subject_id = p_person_party_id
1150: and cont.lead_id = p_security_id
1151: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 1156: hz_relationships rel

1152: AND OBJECT_TABLE_NAME = 'HZ_PARTIES';
1153: cursor lead_contact_exist_csr is
1154: select 'x'
1155: from as_sales_lead_contacts cont,
1156: hz_relationships rel
1157: where cont.contact_party_id = rel.party_id
1158: and rel.subject_id = p_person_party_id
1159: and cont.sales_lead_id = p_security_id
1160: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'