APPS.ASO_ORDER_INT dependencies on HZ_ORG_CONTACTS

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