APPS.IBU_HOME_PAGE_PVT dependencies on HZ_RELATIONSHIPS

Line 217: FROM hz_relationships

213: end if;
214: if (l_party_type = 'PARTY_RELATIONSHIP') then
215: SELECT object_id
216: INTO l_company_id
217: FROM hz_relationships
218: WHERE party_id = l_party_id
219: AND relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
220: AND content_source_type = 'USER_ENTERED'
221: AND status = 'A';

Line 225: FROM hz_relationships p

221: AND status = 'A';
222: elsif (l_party_type = 'PERSON') then
223: SELECT p.object_id
224: INTO l_company_id
225: FROM hz_relationships p
226: WHERE p.subject_id = l_party_id
227: AND p.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
228: AND content_source_type = 'USER_ENTERED'
229: AND status = 'A';