221: l_company_rel_count NUMBER;
222:
223: BEGIN
224: select count(*) into l_company_rel_count from
225: hz_relationships hr
226: where hr.object_id in(
227: select object_id from hz_relationships
228: where party_id=p_contact_party_id
229: and relationship_code='EMPLOYEE_OF'
223: BEGIN
224: select count(*) into l_company_rel_count from
225: hz_relationships hr
226: where hr.object_id in(
227: select object_id from hz_relationships
228: where party_id=p_contact_party_id
229: and relationship_code='EMPLOYEE_OF'
230: )
231: and status<>'I';