APPS.ASO_ORDER_INT dependencies on HZ_RELATIONSHIPS

Line 3332: hz_org_contacts a, hz_relationships b

3328: where party_id = p_party_id and status ='A';
3329: CURSOR org_contact IS
3330: select a.org_contact_id
3331: from
3332: hz_org_contacts a, hz_relationships b
3333: where
3334: b.party_id = p_party_id
3335: --and a.status = 'A' -- status column is obseleted
3336: and b.relationship_id = a.party_relationship_id