DBA Data[Home] [Help]

APPS.IBE_JTA_INTEGRATION_GRP dependencies on HZ_RELATIONSHIPS

Line 236: hz_relationships hr

232: l_company_rel_count NUMBER;
233: BEGIN
234:
235: select count(*) into l_company_rel_count from
236: hz_relationships hr
237: where hr.object_id in(
238: select object_id from hz_relationships
239: where party_id=p_contact_party_id
240: and relationship_code='EMPLOYEE_OF'

Line 238: select object_id from hz_relationships

234:
235: select count(*) into l_company_rel_count from
236: hz_relationships hr
237: where hr.object_id in(
238: select object_id from hz_relationships
239: where party_id=p_contact_party_id
240: and relationship_code='EMPLOYEE_OF'
241: )
242: and status<>'I';