APPS.OE_SYNC_ORDER_PVT dependencies on HZ_RELATIONSHIPS

Line 99: hz_relationships r

95: SELECT org_contact_id
96: INTO l_org_contact_id
97: FROM hz_org_contacts oc,
98: hz_cust_account_roles car,
99: hz_relationships r
100: WHERE r.party_id = car.party_id
101: AND r.relationship_id = oc.party_relationship_id
102: AND cust_account_role_id = p_cust_acct_role_id
103: AND r.directional_flag = 'F'