DBA Data[Home] [Help]

APPS.IBE_JTA_INTEGRATION_GRP dependencies on HZ_RELATIONSHIPS

Line 225: hz_relationships hr

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'

Line 227: select object_id from hz_relationships

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';