APPS.ASO_ORDER_INT dependencies on HZ_RELATIONSHIPS
Line 3166: hz_org_contacts a, hz_relationships b
3162: where party_id = p_party_id and status ='A';
3163: CURSOR org_contact IS
3164: select a.org_contact_id
3165: from 3166: hz_org_contacts a, hz_relationships b 3167: where
3168: b.party_id = p_party_id
3169: --and a.status = 'A' -- status column is obseleted
3170: and b.relationship_id = a.party_relationship_id